User - select from master database query.

• Matthew24

  SSCommitted

  Points: 1736

  More actions

  October 14, 2012 at 12:38 pm

  #269506

  Hi,

  I need to access the master table to checkl the applications logged into the database for a licensing issue.

  If i run the following code

  select * from master.dbo.sysprocesses

  when logged in as the SA or a SQL admin, it shows me what I expect. If I use it in a basic user login context, it will only show me the row relating to that login.

  The guest security is enabled on the Master DB.

  Is there a good way to obtain this data with a baisc user login?

  Thanks,

  Matthew

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  October 14, 2012 at 2:15 pm

  #1548968

  The user must have view server state permission, to grant user that permission execute:

  GRANT VIEW SERVER STATE TO yours_user;

  http://msdn.microsoft.com/en-us/library/ms179881.aspx sys.sysprocesses (Transact-SQL)

  http://msdn.microsoft.com/en-us/library/ms186717.aspx GRANT Server Permissions (Transact-SQL)

• Matthew24

  SSCommitted

  Points: 1736

  More actions

  October 15, 2012 at 4:17 am

  #1549059

  e4d4 (10/14/2012)

  ---

  The user must have view server state permission, to grant user that permission execute:

  GRANT VIEW SERVER STATE TO yours_user;

  http://msdn.microsoft.com/en-us/library/ms179881.aspx sys.sysprocesses (Transact-SQL)

  http://msdn.microsoft.com/en-us/library/ms186717.aspx GRANT Server Permissions (Transact-SQL)

  Thanks e4d4.

  All working