Post reply

Restore database role??

  • August 15, 2002 at 12:06 pm

    #158292

    Can a role be created so that a user only has restore capabilities to only a specified database? IF that is not possible can he/she only have backup and restore capabilities without granting him the ability to backup or restore any other databases?

    thanks

    Mona

  • September 11, 2002 at 7:38 pm

    #436358

    What you can do is put a password for a media set for a given database. And only the user with proper permissions to restore a database must know the password you specified in the backup set.

    This way you can restring the user that restores a database

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

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