June 19, 2013 at 1:09 am
To run sp's what type of role we assign to user?
June 19, 2013 at 1:49 am
Grant Execute...
http://msdn.microsoft.com/en-us/library/ms345484.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 19, 2013 at 5:08 am
There is no specific role that enables the execution of stored procedure, even if the user has rights to do whatever the proc does.
You will have to manually grant execute on the stored proc to the user(s).
Another approach is to create a custome role, grant execute on all stored procedures to that role and then add users into the role.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply