security, execute, schema - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Browse by Tags

Need to grant permission to view stored procedure text Published 10 September 7 3:24 AM | SSQA.net: 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...

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