sysperfinfo permissions

Question

Post reply

sysperfinfo permissions

cherie-817709

Right there with Babe

Points: 749
More actions
August 26, 2008 at 3:56 pm

#191662

Are there any special permissions needed to perform select on sysperfinfo table. I tried giving the login db_reader rights for master db but it doesn't work. Tried giving exclusive select right on the view but still doesn't work..
Any help appreciated.

Viewing 6 posts - 1 through 5 (of 5 total)

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

Muhammad Tariq Ten Centuries Points: 1020 More actions · Answer 1

Try it,

Grant View Server State To [userid/login]

Tariq
master your setup, master yourself.
http://mssqlsolutions.blogspot.com

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 2

If you want a user to be able to use sysperfinfo table, you can do one of the fallowing:

1) Add the login as a user to master database and grant the user permissions on sysperfinfo table (in the master database).

2) If you want to let anyone read this info you just grant select permissions to public in the master database and all logins will be able to read the table.

Just out of curiosity – why do your users need to read this table?

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 3

Muhammad Tariq (8/27/2008)
Try it,
Grant View Server State To [userid/login]

Since Cherie asked about sysperfinfo table, my guess is that Cherie is using SQL Server 2000. You can grant view server state permissions from SQL Server 2005.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

cherie-817709 Right there with Babe Points: 749 More actions · Answer 4

Thanks a lot for the reply..

FYI: its actually sql 2005 express edition

cherie-817709 Right there with Babe Points: 749 More actions · Answer 5

Thanks Muhammad..it worked!!

Adi..we have a group who monitors some of the servers located at different locations and they use an application which needs to view this table.