Activity Monitor Permission

Question

Activity Monitor Permission

chalapathi.pinisetty

SSChasing Mays

Points: 612
More actions
October 19, 2010 at 8:17 pm

#225289

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

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

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

sobhankishore Valued Member Points: 56 More actions · Answer 1

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

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 2

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

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

Rune Bivrin SSCrazy Eights Points: 8509 More actions · Answer 4

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.

chalapathi.pinisetty SSChasing Mays Points: 612 More actions · Answer 5

chalapathi.pinisetty

SSChasing Mays

Points: 612

October 20, 2010 at 4:50 am

#1239573

Thanks For Your comments.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 6

Daniel Bowlin

SSC-Dedicated

Points: 34566

October 20, 2010 at 7:41 am

#1239686

Good question, thanks.

UMG Developer SSChampion Points: 13482 More actions · Answer 7

UMG Developer

SSChampion

Points: 13482

October 21, 2010 at 3:07 pm

#1240615

Thanks for the question.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

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

Dhruvesh Shah SSCrazy Points: 2303 More actions · Answer 9

Simple & excellent question. Learned about permissions

UMG Developer SSChampion Points: 13482 More actions · Answer 10

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)