What are the minimum SQL Server 2000 security privileges that a user needs
to use
the KILL command within SQL Server?
Thanks,
KILL permissions default to the members of the *sysadmin* and
*processadmin* fixed database roles, and are not transferable.
See BOL:
http://msdn.microsoft.com/library/de...kf-kz_1zos.asp
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Joe K. wrote:
>What are the minimum SQL Server 2000 security privileges that a user needs
>to use
>the KILL command within SQL Server?
>Thanks,
>
Showing posts with label needsto. Show all posts
Showing posts with label needsto. Show all posts
Friday, March 23, 2012
Kill SPID Minimum SQL Server Privileges
What are the minimum SQL Server 2000 security privileges that a user needs
to use
the KILL command within SQL Server?
Thanks,KILL permissions default to the members of the *sysadmin* and
*processadmin* fixed database roles, and are not transferable.
See BOL:
http://msdn.microsoft.com/library/d...br />
1zos.asp
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Joe K. wrote:
>What are the minimum SQL Server 2000 security privileges that a user needs
>to use
>the KILL command within SQL Server?
>Thanks,
>
to use
the KILL command within SQL Server?
Thanks,KILL permissions default to the members of the *sysadmin* and
*processadmin* fixed database roles, and are not transferable.
See BOL:
http://msdn.microsoft.com/library/d...br />
1zos.asp
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Joe K. wrote:
>What are the minimum SQL Server 2000 security privileges that a user needs
>to use
>the KILL command within SQL Server?
>Thanks,
>
Subscribe to:
Posts (Atom)