November 14, 2009 at 1:25 am
Is there in option in SQL server 2005, to create a new login and give him the privileges to take BackUp of Databases and also Resotre Databases only, and no other rights?
Bhavesh
November 14, 2009 at 2:06 am
You can provide that user with db_backupoperator fixed database role on all databases which that user will have the privilages to backup.
November 14, 2009 at 2:25 am
Hi Pradeep,
If I give user 'db_backupoperator' database role, it allows the user to take backup. -- Half the Problem solved.
But It does not allow the user to Restore the Database! So, I guess more privileges are required?
Bhavesh
November 14, 2009 at 2:38 am
I gave dbcreator fixed server role to the user i created and this user was able to restore the database.
can u try that out.
November 14, 2009 at 2:59 am
Hey, it works now. The new user can restore the database after being assigning 'dbcreater' server role.
But is this the optimal solution?
Because I want to give the user bare minimum privileges, so that he can perform backup and restore only.
Bhavesh
November 14, 2009 at 3:02 am
when we are restoring a database, we are essentially creating a new database and hence i tried for dbcreator role. I think this should be an optimal solution.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply