May 5, 2010 at 7:20 am
Hi Experts,
We need to give a developer execute permission on sp_lock ,is it possible to achive the same without giving him sysadmin privileage?
May 5, 2010 at 8:10 am
VIEW SERVER STATE Permission is the way to GO.
Maninder
www.dbanation.com
May 5, 2010 at 8:20 am
Thanks Manider.
What all the things he can acces with that permission??
Granting him view server will make him equal to serveradmin????
May 5, 2010 at 8:29 am
yes that is TRUE. so you can search for alternate methods, like there are many custom SP's which do the same thing as the sp_lock.. Or Create another sp_lock SP with the definition of the sp_lock and grant permissions to that custom SP.
Maninder
www.dbanation.com
May 5, 2010 at 10:20 am
view server state is not the same as sysdmin. It allows the user to view server level objects, not manipulate them. There is also a view database state. You could try using that first.
"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
May 6, 2010 at 1:25 am
Thanks Grant for the info..
VIEW DATABASE STATE is not enough...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply