Home Forums SQL Server 2005 Administering DBO permissions on database replaced during RESTORE RE: DBO permissions on database replaced during RESTORE

  • You could develop a custom restore procedure that scripts out existing permissions into a table in database like MSDB and then at the end of restore, trigger a SQL agent job that reads the permission strings from table in MSDB database and executes them..

    SQL agent job should be run under an account which has privileges to create users and apply permissions..