davewilliamson55555@hotmail.com
3/22/2007 6:29:00 PM
Context=SQL Server 2005 Express
End user has the following server roles:
db_creator
diskadmin
End user has the following database roles:
db_backupoperator
db_datareader
db_datawriter
db_owner
Is there a way that the user can restore a database using a database
backup that does not have that user's rights (was made by another
server or was made before user existed) and also have rights to the
restored database as if it was the database prior to the restore?
Currently if the user does the restore, the database is restored
successfully; however, since the user did not exist when the backup
was made, the user can not access the newly restored database.