Grant user permission to execute store procedures | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Grant user permission to execute store procedures

I create a new user on the database, try to grant this user permission to execute all store procedures created by dbo. How can I grant permission to let this user to execute store procedure automatically? Thanks,
– Kathy
Create a database role, and add the login to this role. When you create a procedure, make sure you give the database role permission to execute the procedure. Now you don’t have to worry about permissions for individual logins, and you still have logins with no permissions at the server or database level.
refer *GRANT * from BOL for more. Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

Thanks, I use "grant execute on procedure_name to login" in every store procedure. It works.