May 27, 2010 at 8:48 am
What are the dis advantages of giving " View Server State " permissions to a non DBA ? I am trying to find if there are any risks and if somethings happens will that be fixable ?
June 1, 2010 at 7:12 am
any comments on this ? 😎
June 2, 2010 at 10:48 am
I personally think that the risk is minimal and have granted it to non-dbas. I think I read something like it can show row counts or sql code or something (sorry - I don't remember) that you may not want others to see. We determined the benefit of granted this access far exceeded the potential risk.
Cindy
October 14, 2010 at 1:42 pm
Can non sys admin be given the previalge to KILL other processess, if so what would be the best method?
October 14, 2010 at 5:03 pm
I am trying to create a stored procedure where in i can give option to one of my developer to KILL sql sessions on a developmenet server. how would i do this without granting sysadmin or process admin previalges to that user.
I tried "execute as owner" from a stored proc but did not work and also didnt give any error message.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply