SQL Server Performance Forum – Threads Archive
Grant user permission to execute store proceduresI 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,
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
"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.