List of objects that require VIEW SERVER STATE permission

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  September 26, 2024 at 10:03 pm

  #4462863

  Hi all,

  I need a list of objects (DMV's and probably other objects) that require VIEW SERVER STATE permission.

  Our DB security team is asking me why I need it. I can only recall sys.dm_exec_requests from the top of my head.

  Will appreciate of somebody would paste a whole list.

  Thanks

• Emperor100

  SSCrazy

  Points: 2173

  More actions

  September 27, 2024 at 2:44 pm

  #4463105

  Following is a partial list

  sys.dm_exec_requests: Provides information about each request that is executing within SQL Server.

  sys.dm_exec_sessions: Contains information about all active user connections and internal tasks.

  sys.dm_exec_query_stats: Returns aggregate performance statistics for cached query plans.

  sys.dm_os_wait_stats: Provides information about all the waits encountered by threads that executed.

  sys.dm_os_sys_info: Returns a miscellaneous set of useful information about the computer, SQL Server instance, and resources.

  sys.dm_exec_connections: Contains information about the connections established to SQL Server and the details of each connection.

  sys.dm_os_tasks: Provides information about the tasks that are currently being executed by SQL Server.

  =======================================================================