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:
GRANT SELECT ON SCHEMA::[dbo] TO [DOMAIN\user]
GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [DOMAIN\user]
- The other is through the GUI: Continue reading