Re: processadmin cannot kill

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/15/04

  • Next message: Phil: "Re: master..xp_cmdshell Error 997 from GetProxyAccount" 
    Date: Tue, 15 Jun 2004 09:03:13 +0530

    Hi,

    It is not required to stop and start sql server after giving a role. Can you
    try execution the below in query analyzer to create a SQL Server login and
    assign processadmin role.

    sp_addlogin <Login_name>
    go
    sp_addsrvrolemember <login_name>,processadmin

    After executing the script, login to Querry analyser using the new sql
    server login.
    Execute sp_who to identify the process id and execute KILL <SPID> to kill a
    process.

    Once you are ok with this, try killing the process from Enterprise manager
    by registering using this new user. 

    --
Thanks
Hari
MCDBA
"Jason" <jeliason@youth-guidance.org> wrote in message
news:1c7e101c4524e$e2872190$a001280a@phx.gbl...
> We are trying to enforce some security on our SQL server,
> and I am trying to move several people away from logging
> on to enterprise manager with the sa user and password.  I
> am hoping to use Windows Authentication, but I am having
> problems with a user not being able to kill processes.  I
> have given the user access to all of the databases and
> added them to the processadmin role.  They still cannot
> kill processes through enterprise manager.  The SQL server
> itself has not been topped & restarted, but that shouldn't
> be nescisary, right (?).
  • Next message: Phil: "Re: master..xp_cmdshell Error 997 from GetProxyAccount"

    Relevant Pages

    • Re: Execute Persmission denied on object sp_OACreate
      ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
      (microsoft.public.sqlserver.security)
    • processadmin cannot kill
      ... We are trying to enforce some security on our SQL server, ... and I am trying to move several people away from logging ... on to enterprise manager with the sa user and password. ... problems with a user not being able to kill processes. ...
      (microsoft.public.sqlserver.security)
    • RE: exec sp_help_job user account rights
      ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
      (microsoft.public.sqlserver.security)
    • Re: SSIS - OLE DB Command - how to retrieve query results ???
      ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
      (microsoft.public.sqlserver.dts)
    • RE: xp_cmdshell, ownership chaining, sql 2000
      ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
      (microsoft.public.sqlserver.programming)
    • Quantcast