Give Rights to KILL process to non SA Users

[pgthyagu]

Hi

Is it possible to give the right to execute KILL command to ordinary user. The User should be able to kill only his own processes. The User should not be added to any Server Roles.

Is there any WorkAround ?

Thanks
Thiagu

 

[tlbroadbent]

In SQL 2000, KILL permissions default to the members of the sysadmin and processadmin fixed database roles, and are not transferable. You can assign a user to the processadmin fixed server role. Note: They can then kill all user processes.

Example:
sp_addrolmember 'pgthyagu', 'processadmin'

In SQL 7, KILL permissions default to the members of the sysadmin fixed database roles, and are not transferable. You cannot allow users to kill processes without making them administrators.

Personally, I don't believe users should have this capability. The potential for problems and abuse is too great. DBAs should handle the job of monitoring servers and controlling processes. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.