GRANT Schema Permissions

Background: I had a user that needed to be able to read, but not execute, stored procedures in the DBO schema. I used these methods below to achieve this task.

There are two methods to granting schema permissions in SQL server.

  • One is through T-SQL commands:

  • The other is through the GUI:
  1. Right click on the database user you wish to grant permissions to and select Properties:
  2. Click on Search for securables, then select Specific objects… and click OK.
  3. Click on Object Types…,scroll down until you find Schemas, select it and then click OK.
  4. Click on Browse, scroll down until you find the Schema you are looking for (in this case DBO), select it and then click OK.
  5. Chose the appropriate permission needed for the user (in this case Grant Select and Grant View definition).                    

Leave a Reply

Your email address will not be published.

HTML tags are not allowed.