Create A role and grant it a permission on a DB Schemas.
How to grant a permission?
Grant permissions
Grant permissions to specific objects in Database using dynamic SQL.
GRANT Column Level Permissions
To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.
Subscribing to our newsletters gets you:
Steve Jones Editor, SQLServerCentral.com