stored procedure and user access | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

stored procedure and user access

if we need to give execute permission and the user wants to view all the stored procedures in that database , what kind of permission he need? is he need to be the db owner?
I am not about this but Check db_ddladmin database role instead dbo owner… MohammedU.
Moderator
SQL-Server-Performance.com
DB_DATAREADER fixed role is enough to allow users to view the views. If you want to restrict for certain users then create a specific role and grant explicit view permission. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>