Post reply

Denying access to kill spid

  • October 19, 2009 at 12:43 pm

    #211161

    Hi,

    I was wondering if there is a way to deny a user access to kill spid's who is a owner of the master database.

  • October 19, 2009 at 5:10 pm

    #1067872

    Hi,

    User who is only "only" db_owner of the master database cannot kill any process.

    Kill statement requires membership in the sysadmin or processadmin fixed server roles.

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

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