sorry to reply to old thread but have same scenario with one addition = To repeat the scenario ==> "Suppose if I create a database on a development box as db_owner and then restore the backup of production version from another server onto this database, I am no longer able to access the database after RESTORE. This is because permissions are stored within the database and they get replaced during RESTORE. As I don't have db_owner permissions in production and even if I use sp_change_users_login, it won't fix the issue. Is there any way db_owner permissions can be given after RESTORE again?

We would like to give the developers ability to restore the database but after restoration, what's happening is that they are forced to contact DBA to get db_owner permissions due to permissions getting replaced. Is there any granular permission which can be given to developers at SERVER level such that they can run below command to get their db_owner privilege back without adding them to sysadmin role. alter authorization on database:: to [login]" <==

Same situation; due to separation of duties developers have dbo on old box but DB is copied to higher environment and they will not be there, I have other users that are not on dev and cannot be on dev box so how can I add DBO to these users afe DB is restored via a job