SP_WHO2 on SQL 2005

SP_WHO2 on SQL 2005

• ondrejsv

  It looks like sp_who2 is not documented yet in Books Online. I'll open a bug to address this.

  I expect that sp_who2 has similar permission requirements with sp_who.

  http://msdn2.microsoft.com/en-US/library/ms174313.aspx

  The user must have VIEW SERVER STATE permission on the server to see all executing sessions on the instance of SQL Server. Otherwise, the user sees only the current session.

  So, VIEW SERVER STATE is the permission that you need to see everyone.

  Also, see the page on sysprocesses, on top of which both sp_who and sp_who2 are implemented:

  http://msdn2.microsoft.com/en-us/library/ms179881.aspx

  Thanks
  Laurentiu

  
  
  

• Tera_Dragon

  VIEW SERVER STATE allows its grantees access to a lot of information in the server. Rather than granting the permission to a regular user, consider wrapping access to specific resources into a signed stored procedure and associate the permission with the certificate used to sign such stored procedures.

  For another alternative and additional information on this permission, see http://msdn2.microsoft.com/en-us/library/ms188754.aspx.

  Thanks
  Laurentiu

  
  
  

• hazz

  i was wondering if it is safe to grant these permissions to a regular user

  Anything i should be cautious about

  thanks

  
  
• SP_WHO2 on SQL 2005