• Infact the issue that we run into most often is that some of these folks in prod have db_reader access whereas in dev they want full control as dbo so they can do whatever it is that would like. So my goal is to extract permissions from dev environments and just re-apply them after the restore.

    Would you be kind enough to share your script.

    Thanks