Post reply

Restore roles ?

  • September 14, 2005 at 3:48 am

    #165947

    Hi everyone.

    Need to allow an SQL user the ability to perform SQL restores.

    Would like to try to avoid the user being in the sysadmin group if at all possible.

    The user is has db_backupoperator permissions to perform the required backup tasks.

    Any ideas how the restore permission can be granted ?

    thanks

  • September 14, 2005 at 6:27 am

    #589656

    Cant you just give him db_owner permissions for the database he can restore.

  • September 14, 2005 at 7:08 am

    #589688

    db_owner won't work if the database doesn't already exist on that instance of SQL Server.  In that case the user must be in the dbcreator fixed server role.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

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

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