Post reply

Developers kill a process...

  • July 8, 2008 at 10:36 am

    #122393

    Is there a way to allow a developer to kill a process without granting them the sysadmin role? ...this would not be for our production environment. 🙂

    I was thinking of a stored procedure where they do a run as...

    Any suggestions - or comments would be a appreciated.

    Thank you in advance!

    Jen

  • July 8, 2008 at 11:03 am

    #839657

    Check Processadmin permissions.

    Maninder
    www.dbanation.com

  • July 8, 2008 at 11:07 am

    #839661

    You could try a stored procedure with a KILL statement and EXECUTE AS a login with sysadmin or processadmin membership. Another option is to add developers to the processadmin server role.

    Greg

  • July 8, 2008 at 11:23 am

    #839672

    I think Processadmin might be exactly that I am looking for! What a handy built in server role...I guess I just forgot about it. 🙂

    Thanks!

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

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