January 11, 2011 at 1:28 am
i have one user that has sysadmin permision .i have 13 user that has only public permisison .
i dont want to give 13 user sysadmin permision but i want to get permision to debug store procedure to them .
they have error : failed to start debuger
execution permision denided on object sp_enable_sql_debug
i go to master \ sp_enable_sql_debug and enable execute to user developer and gust and public
grant execute on sp_enable_sql_debug to developer
but i have the same error?what do i do?
January 11, 2011 at 3:32 am
a.e.ghorbani (1/11/2011)
i have one user that has sysadmin permision .i have 13 user that has only public permisison .i dont want to give 13 user sysadmin permision but i want to get permision to debug store procedure to them .
they have error : failed to start debuger
execution permision denided on object sp_enable_sql_debug
i go to master \ sp_enable_sql_debug and enable execute to user developer and gust and public
grant execute on sp_enable_sql_debug to developer
but i have the same error?what do i do?
It can't be done without giving them sysadmin permission.
Read the following thread for more information:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply