Post reply

admin priv's for an SP

  • December 24, 2003 at 8:49 am

    #161013

    Is it possible to grant admin privileges to a specific stored procedure in the master db.

    This is for a user trying to kill users and put the db in single user mode before restoring.

  • December 24, 2003 at 9:01 am

    #487767

    You can assign the processadmin role to allow your user to kill a process. If the user is also db_owner or a member of dbcreator, he can put the db in single user mode as well. In order to restore, the user needs dbcreator.

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

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