This content has been marked as final. Show 2 replies
Is there any tools available to perform deployment such as running scripts without DBA intervention instead of developer submitting scripts to DBA to run?
Scripts do not know, or even care, whether they are being run by a developer or a DBA.
The user running the script needs to have the requisite privileges on the objects being manipulated by the scripts. If that user has the required privileges the script can execute successfully; if not the script will fail.
Any tool, including the venerable sql*plus can run a script successfully.
So, you could use a tool like Hudson to do builds on a schedule, and it could run SQL*Plus (or run something like Ant which would run SQL*Plus) to execute the scripts. You'd probably want to give it the username and password for a user with enough database privileges (like CREATE ANY) to build the objects in the script, but without FULL DBA privileges, i.e. don't grant the DBA role.