Activity Monitor Permission

  • Comments posted to this topic are about the item Activity Monitor Permission

  • The easiest way is to just open a connection (i.e. using sqlcmd or Management Studio) using your sysadmin credentials and issue the following statement:

    GRANT VIEW SERVER STATE TO <<login name>>

    This will grant <<login_name>> VIEW ANY STATE permission.

    Sobhan Kishore Chintala

  • As per the BOL:

    To view the Activity Monitor in SQL Server 2005 and SQL Server 2008, a user must have VIEW SERVER STATE permission.

    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.

    Thanks

  • Nice question. I got it right because I just checked what rights I have on the development server and what rights I have on the production server.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good question!

    Maybe I shouldn't admit it, but Activity Monitor is something I had completely missed. DOH!


    Just because you're right doesn't mean everybody else is wrong.

  • Thanks For Your comments.

  • Good question, thanks.

  • Thanks for the question.

  • Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Simple & excellent question. Learned about permissions

  • In addition if you want to be able to view the "Data File I/O" section you have to have one of the following permissions: CREATE DATABASE, ALTER ANY DATABASE, or VIEW ANY DEFINITION. (Required for sys.master_files)

Viewing 11 posts - 1 through 11 (of 11 total)

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