In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
1 Answer
Read Dynamic Management Views and Functions
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
There are two types of dynamic management views and functions:
- Server-scoped dynamic management views and functions. These require
VIEW SERVER STATEpermission on the server. - Database-scoped dynamic management views and functions. These require
VIEW DATABASE STATEpermission on the database.
- 5I would mention that there are security implications for allowing the use of DMV's and DMF's -- in particular, they allow looking at queries and query parameters, which can contain confidential info. Not a problem if there is only one database on the server and the user can already look at everything in the DB. But how often is that the case?jmoreno– jmoreno2016-05-13 00:36:58 +00:00Commented May 13, 2016 at 0:36
- 1VIEW SERVER STATE is a sufficient privilege which, applied to the login account, also induces VIEW DATABASE STATE in all databases in which the login account is associated with an SQL user. However, it would also be necessary to have the SHOWPLAN privilege to be able to read the query execution plans...SQLpro– SQLpro2024-02-10 08:34:44 +00:00Commented Feb 10, 2024 at 8:34