16 Mar Ad hoc SQL statements in Production environments by a developer
I had a client email me today the following:
“Is it normal to have IT dev/support group run SQL queries in production to fix errant/stuck data in an Oracle EBS shop? As an example have an data issue that is listing the load weight as 0LB and have IT fix that through an SQL query directly in production?”
Here was my response:
“No. This is not normal for two reasons:
1. Developers should not have access to run scripts in Prod. Any scripts should be developed by the developers, executed by the DBAs in a non-prod environment, tested by an end user then executed by the DBAs in Prod.
2. May or may not be an issue… SQL scripts can either be supported or not supported by Oracle depending on how they are written. If they call a public API, generally they are supported. If there is no public API, Oracle should be providing the data fix script. Otherwise, they’ll not support it and the execution of it may void your support agreement.”