Friday, March 23, 2012
Grant "view server state"
New SQL User...v2005. I have been directed to Grant "View Server State" permissions to a user. However, I don't see it in the list of choices I can grant access to in Permissions, nor is there a visible hyperlink in an area that it is expected to be. I have also tried setting that permission in a query window to no avail as well. I can provide additional info if someone would like to work with me on this issue. Thanks!"VIEW SERVER STATE" is a server level permission and not a database level permission. So you cannot grant it to a database user. You have to grant to a login. hope that helps,
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment