Activity Monitor Permission

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Chalapathi... » Activity Monitor Permission

11 posts, Page 1 of 2

1 2 »»

Activity Monitor Permission

Rate Topic

Display Mode

Topic Options

Author

Message

chalapathi.pinisetty

Posted Tuesday, October 19, 2010 8:17 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:56 PM
Points: 500, Visits: 35

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

Post #1007422

sobhankishore

Posted Tuesday, October 19, 2010 9:26 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 2:33 AM
Points: 14, Visits: 259

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

Post #1007437

Hardy21

Posted Tuesday, October 19, 2010 11:56 PM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 877, Visits: 1,159

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

Post #1007471

Koen Verbeeck

Posted Wednesday, October 20, 2010 12:22 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 9,376, Visits: 6,472

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.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1007479

Rune Bivrin

Posted Wednesday, October 20, 2010 4:05 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:28 AM
Points: 2,659, Visits: 720

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.

Post #1007564

chalapathi.pinisetty

Posted Wednesday, October 20, 2010 4:50 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:56 PM
Points: 500, Visits: 35

Thanks For Your comments.

Post #1007603

Daniel Bowlin

Posted Wednesday, October 20, 2010 7:41 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:10 PM
Points: 2,673, Visits: 2,418

Good question, thanks.

Post #1007731

UMG Developer

Posted Thursday, October 21, 2010 3:07 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Thanks for the question.

Post #1008846

SQLRNNR

Posted Tuesday, October 26, 2010 10:33 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Thanks for the question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1010994

Dhruvesh Shah

Posted Sunday, October 31, 2010 8:29 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 25, 2012 9:04 PM
Points: 542, Visits: 187

Simple & excellent question. Learned about permissions

Post #1013660

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions