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,

No comments:

Post a Comment