There are some considerations for deciding if a Developer should be able to include as part of an ETL process , the capacity to change the READ STATE of a SQL database
ALTERpermission on the database. This is an elevated privilege – and may break the organisations sql server security policy
2) Is the developer on the hook for maintaining Production data? What is the developer’s role in supporting production data ?
Read on for the commands as well as additional considerations before you grant these permissions.