We often need to deploy backups of our production database into lower environments to troubleshoot production issues. This led to a production backup that was 8 hours old being put into prod and lose of user work. We would like an additional permission to restrict which environments a backup can be restored into.
Mike,
How do I restrict who can restore backups to prod? I can see the permissions for deployment and backup access neither of these allow me to restrict the ability to deploy a backup into production while still allowing the same backup to be restored in a lower environment. Is there an additional setting of permissions that I am unaware of?
Jesse,
You can currently restrict which people can restore backups to Prod. So you could remove this permission from all users and prevent this issue in the future. If you did need to restore a production database to Prod in the future, you could grant that right to a single user, restore the database, and then remove the permission. Doing it this way means you won't need to wait for changes to the platform.
Hope that helps,
Mike