March 1, 2009 at 12:51 pm
Hi,
Is there a way to allow a login that is not in the Server Role of SA to use the Activity Monitor and sp_who to see all the processes running and connections on a SQL Server?
Thanks,
David
March 1, 2009 at 8:26 pm
ProcessAdmin should work.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2009 at 8:47 am
That allows them to kill of processes...is there a way to just allow lookup only...........and only activity window and only their own......too
March 7, 2009 at 1:02 pm
You would need to write your own activity monitor for that.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2009 at 1:48 pm
You should be able to grant permission to execute sp_who to anyone you want without changing their role.
You probably can't do that with the activity monitor.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 7, 2009 at 6:19 pm
Agreed, Alvin.
March 8, 2009 at 8:48 am
Thanks i will try just giving rights to sp_who
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply