Post reply

SA permissions for Non-SA users eg xp_CMDShell / Kill etc

  • August 25, 2006 at 8:40 am

    #62261

    Hi All,

    I want certain users to be able to kill spid's and also run xp_cmdshell to be able to do thier jobs.

    I tried writing a Stored procedure that would embed all that eg

    Create Procedure USP_Test

    as

    begin

    Exec master.dbo.xp_cmdshell 'NET START'

    end

    I then grant execute permisions to the user, is there anything i can do to allow them run this, without SA rights ?

    Looking forward to your reply.

    Thanks

     

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • August 25, 2006 at 9:03 am

    #656854

    For the xp_cmdshell you could simply grant them excute rights to the xp_cmdsheel stored procedure in the master database.  In terms of killing proccesses, if you add the user to the process admin fixed server role they should be able to execute the kill command.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply