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:
1 2 3 4 5 |
use [database_name] GRANT SELECT ON SCHEMA::[dbo] TO [DOMAIN\user] GO GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [DOMAIN\user] GO |
- The other is through the GUI: Continue reading