| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-04-10 : 12:05:59
|
| Is there a way to allow a user to run activity monitor without making that user system admin |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 12:17:54
|
| Don't think so because with it we can see processes and even kill it. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-04-10 : 12:24:15
|
| I found thisUse Activity Monitor when troubleshooting database locking issues, and to terminate a deadlocked or otherwise unresponsive process.To view the Activity Monitor the user needs VIEW SERVER STATE permission on a SQL Server 2005 server.(Where would be VIEW SERVER STATE permissions be in SQL 2005)To view the Activity Monitor the user needs SELECT permission to the sysprocesses and syslocks tables in the master database on a SQL Server 2000 server. Permission to view these tables is granted by default to the PUBLIC database role.Permission to KILL a process default to the members of the sysadmin and processadmin fixed database roles, and are not transferable. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 23:02:53
|
| >> Where would be VIEW SERVER STATE permissions be in SQL 2005In login's properties -> securables, you can grant permission there or using grant statement. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-04-11 : 11:16:48
|
| Im in Security, Logins, right click properties see securables..Object Types, Servers, EndPoint, Logins.I ran the command in query but do not see anything in the gui.Can you advise....I like to check what it does when running statementsCheers |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-11 : 11:20:15
|
| Use this:GRANT VIEW SERVER STATE TO <<login name>> |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-12 : 00:28:52
|
| Or you can add securable in gui. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-04-12 : 09:48:08
|
| Im not seeing it in the gui under securables..Im a gui person until i know what the commands do then i run them and go check in GUI.I see the options to add securables but what in the pull down options is there view state? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-12 : 19:20:50
|
| You can choose type of securable to add there. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-04-12 : 20:19:53
|
| Got it...had to add all objects of types first then i saw in list.Cheers |
|
|
|
|
Activity monitor