August 20, 2009 at 5:06 am
What is the most secure way to give a user an execute permission on all existing stored procedures and any new ones created by other users,
and the ability to create new stored procedures and have execute permissions on them,
without the ability to do anything else on the server?
August 20, 2009 at 6:45 am
To get them execution permissions, I'd suggest giving them execute on the schema:
GRANT EXECUTE ON SCHEMA :: Dude TO Somebody;
In order for them to create procedures, you have to give them DDL, but you can then revoke every object you don't want them to have access to. If you also grant them security admin, not access admin, they can grant execute on the procedures.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply