Post reply

KILL a process

  • February 10, 2006 at 7:57 am

    #170584

    Is there a way that I can give rights to developers to KILL their own processes without having to make them members of the PROCESS ADMIN Server Role?

    Thanks.

     

  • February 10, 2006 at 9:58 am

    #620211

    No.  From BOL:

    KILL permissions default to the members of the sysadmin and processadmin fixed database roles, and are not transferable.

    "Not transferable" means you can't assign the permission to anyone else.

    Greg

    Greg

  • February 10, 2006 at 9:32 pm

    #620309

    I was hoping that there could be a away around it.

    Thanks for your reply.

  • February 12, 2006 at 7:30 pm

    #620347

    There is a workaround but it requires you to create an exe for them. Make use of approle (with appropriate privileges) and query through sysprocesses to filter out the processes owned by their login accounts (this requires them however to login using windows authentication).

    It's not simple but it is a workaround...

     

    HTH

Viewing 4 posts - 1 through 3 (of 3 total)

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