October 14, 2012 at 12:38 pm
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
October 14, 2012 at 2:15 pm
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)
October 15, 2012 at 4:17 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply