Share via

SQL - Work around other than Grant view server state

Kman 46 Reputation points
2022-02-24T16:37:28.157+00:00

Hello,

is there any way that we can replace the "Grant view server state" with a lower level access but again be able to run DMVs from SSMS?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,671 questions
0 comments
Accepted answer
  1. Tom Phillips 17,731 Reputation points
    2022-02-24T18:09:06.687+00:00

    No.

    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.

    See:
    https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views?view=sql-server-ver15

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.