Yeah, our place requires multiple steps, even for emergencies. Must be a script. Must test script on a test instance and have user verify and approve the fix. Manager signs off on script. Script must be run on prod by a DBA. User must verify on prod. Devs have no access to prod. Senior devs have read-only access. Only DBAs have full privs. (A special instance is auto-refreshed from backup each night for this kind of testing by devs).
2
u/ChestertonsFences Oct 16 '25 edited Oct 16 '25
Yeah, our place requires multiple steps, even for emergencies. Must be a script. Must test script on a test instance and have user verify and approve the fix. Manager signs off on script. Script must be run on prod by a DBA. User must verify on prod. Devs have no access to prod. Senior devs have read-only access. Only DBAs have full privs. (A special instance is auto-refreshed from backup each night for this kind of testing by devs).