Browse by Tags

• execute
• schema
• security
• sql server
• stored procedure
• update
• view definition

Need to grant permission to view stored procedure text
10 September 07 01:24 AM | SQL Master | 2 Comments   

If you need to grant permissions to a login that only needs to view stored procedures (contents not just names of SP's). Further you may not want to grant that login with DB_OWNER or DB_DDLADMIN roles within that database, so how to achieve this task? Read More...

Filed under: sql server, security, stored procedure, schema, permissions, execute, view definition, update