Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fromper
Starting Member
33 Posts |
 Posted - 2008-11-03 : 17:08:10
|
| I need a user to have access to track all processes logged into ourSQL Server. In other words, I need them to be able to querymaster.dbo.sysprocesses. I've already written the query they'll use,and it works when logged in as sa, but not when logged in as the userwho needs to be able to do this.I know that on SQL Server 2005, the syntax to grant this permissionwould be:grant view server state to <username>Unfortunately, I need to do this on an older server running SQL Server2000, and that syntax doesn't work to grant the permission. Any ideawhat I'd need to grant the user to make this work?Thanks in advance,--Richard |
|
|
|
|
|
Security for server tables on SQL 2000