Post reply

Grant access to View Activity Monitor in SQL Server 2000

  • April 9, 2010 at 9:15 am

    #97267

    Our Developers want to be able to View the Activity Monitor in Production.

    Is there harm in giving them GRANT VIEW SERVER STATE TO login name

    or is there another way to give them this access??

  • April 9, 2010 at 9:49 am

    #1149232

    If you didn't want to do that you could just tell them to execute the query 'sp_who2' which shows pretty much the same thing.

  • April 9, 2010 at 10:34 am

    #1149268

    Thank you : )

  • April 19, 2010 at 7:08 am

    #1153787

    How do I give a user access to execute sp_who2?

  • April 19, 2010 at 7:49 am

    #1153831

    They would need the VIEW SERVER STATE permission. I would say it would be fine to give them this right.

  • April 19, 2010 at 7:56 am

    #1153841

    Thank you!!!

  • April 19, 2010 at 8:12 am

    #1153858

    I feel stupid here but........

    when i try and run

    GRANT VIEW SERVER STATE TO login name

    Incorrect syntax near the keyword 'VIEW'.

  • April 19, 2010 at 8:46 am

    #1153885

    HA! No need to feel stupid.. after not being able to figure out why you would get that error considering it was the right syntax I noticed you are on a SQL 2000 Server! There is no VIEW SERVER STATE permission in 2000.

    MSDN LIBRARY:

    To view the Activity Monitor on a SQL Server 2000 server, a user must have SELECT permission to the sysprocesses and syslocks tables in the master database. Permission to view these tables is granted by default to the public database role.

  • April 19, 2010 at 8:48 am

    #1153888

    : ) Thank you!!!!!!!!!!!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply