Re: Process Admin Server Role Can't use Kill command
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 11/04/02
- Next message: B Andrei: "Database securing problem"
- Previous message: Javier Rosas: "Change user name"
- In reply to: Kevin Haglund: "Process Admin Server Role Can't use Kill command"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Sun, 03 Nov 2002 21:31:13 -0700
Not sure what error they get when executing a KILL but If
the users get the error:
User does not have permission to use the KILL statement.
then I'd check what account they are using to log into SQL
Server - possibly they are using a SQL login instead of
Windows authentication and the account that is a member of
process admins. You may want to verify that the user is a
member of the process admin role using IS_SRVROLEMEMBER.
If they get the error:
Only user processes can be killed.
that's probably self explanatory where they are trying to
kill a system process.
-Sue
On Fri, 1 Nov 2002 12:12:13 -0800, "Kevin Haglund"
<khaglund@tileshopsuperstore.com> wrote:
>I need to allow some users to kill process that are
>causing blocks. So I created a domain group and added it
>to the process admin server role but these users still
>don't have access to the Kill command in Enterprise
>Manager or through TSQL statements. I couldn't find any
>information on the Kbase and wanted to know if anyone else
>is running in to the same problem. Dose any one know of
>a solution to provide access to the kill command without
>making user SQL Admins?
>
>Thanks
>
>Kevin Haglund
- Next message: B Andrei: "Database securing problem"
- Previous message: Javier Rosas: "Change user name"
- In reply to: Kevin Haglund: "Process Admin Server Role Can't use Kill command"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
