Re: sysprocesses

From: "Russell Fields" <russellfields@xxxxxxxxxx>
Date: Tue, 14 Aug 2007 13:12:18 -0400

Grant VIEW SERVER STATE to the logins or groups that should have these
rights.

I have a Windows group named something like Domain\ServerNameViewServerState
and GRANT VIEW SERVER STATE TO Domain\ServerNameViewServerState. At the
domain level, adding or subtracting logins as members of the group will
control whether those logins have this right.

RLF
<dnlgauthier@xxxxxxxxxxx> wrote in message
news:1187110036.115100.273990@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

prior to SQL Server 2005, a login was able to select * from
master..sysprocesses and see all active SPIDs. Now using SQL Server
2005 the same select only returns the SPID for the active connection,
unless the user has "processadmin" role enabled. How can I view all
active connections WITHOUT having to enable the processadmin role for
the user ?

Follow-Ups:
- Re: sysprocesses
  - From: dnlgauthier

References:
- sysprocesses
  - From: dnlgauthier

Prev by Date: sysprocesses
Next by Date: Re: sysprocesses
Previous by thread: sysprocesses
Next by thread: Re: sysprocesses
Index(es):
- Date
- Thread

Relevant Pages

Re: creating logins in stored procedure (yukon)
... since you are using execute I have to grant permission to create the login, ... my hope was to write a sp to create logins without using exec, ... could grant only execute on that sp, ...
(microsoft.public.sqlserver.security)
Re: How can I see what permissions "VIEW SERVER STATE" has?
... The problem is that I want to grant some developers access to certain ... But before I grant them VIEW SERVER STATE ... those permissions. ...
(microsoft.public.sqlserver.security)
Re: How can I see what permissions "VIEW SERVER STATE" has?
... But before I grant them VIEW SERVER STATE ... those permissions. ... and grant that login VIEW SERVER STATE. ...
(microsoft.public.sqlserver.security)
Re: Cannot view logins from syslogins, sys.server_principals, sys.server_role_members in SQL 2005
... can view all logins, but it only returns itself and sa. ... GRANT VIEW DEFINITION ON LOGIN::loginname TO youruser ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
(microsoft.public.sqlserver.security)
Re: Server instances and limiting connectivity
... Logins are what controls access to an instance You would ... grant the login access to the one instance and not the ... The logins are granted access by instance, ... BUILTIN\Administrators are added as sysadmins on SQL Server ...
(microsoft.public.sqlserver.security)