37

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?

hyty
  • 431
  • 1
  • 5
  • 6

1 Answers1

37

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 STATE permission on the server.
  • Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.
Mitch Wheat
  • 466
  • 3
  • 10
bindbn
  • 5,153
  • 2
  • 26
  • 23
  • 5
    I 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 May 13 '16 at 00:36