Use of Grant view server state to login

• Saidba17

  SSC Eights!

  Points: 818

  More actions

  May 12, 2010 at 9:56 am

  #235037

  Hi,can anyone explain me what's the advantage of issuing

  Grant view server state to login on master database

• Akkare

  SSCrazy

  Points: 2848

  More actions

  May 13, 2010 at 12:05 am

  #1166647

  Hi

  The Active Monitor tool requires VIEW SERVER STATE permission; this permission is required to select from DMVs such as sys.sysprocesses.

  Binu

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  May 13, 2010 at 5:16 am

  #1166766

  and system stored procedure like sp_lock ,sp_helpdb