how to manage DEV STG PRD systems
Hi all,
what is the best approach to manage the three systems mentioned in the subject.
our requirement is
Developers will have full access to DEV
Changes to be moved by DBA first to STG and the PRD
Developers need access to PRD in case of troubleshooting the issues. the access can be Schema level on specific objects (mentioned in the form)
We try to have following methodology please advise if this is correct
1. Restrict access to PRD to application Schema users only
2. Create developer accounts on PRD and lock them
3. Exp/Imp changes requested through approved change form (DBA will do)
4. For troubleshooting unlock the developer account and grant the access on schema/objects mentioned in approved form
5. Revoke the roles/privileges from developer account when troubleshooting is completed and lock the account.
Is there any other way this can be managed. Granting and revoking of roles is bit lousy and time consuming even though it is through scripts.
Another problem we face is to manage the passwords in Coldfusion application servers. There are around 50 database schema which are used in 7 application servers. In order to change the passwords we need to change them on 7 places. Is there way around to make to bit easier.
Thanking you in advance for your help and advise.
regards
Aijaz