This discussion is archived
2 Replies Latest reply: Mar 12, 2013 5:30 AM by jflack RSS

Deployment tools queries

user2429896 Explorer
Currently Being Moderated
Hi,

Is there any tools available to perform deployment such as running scripts without DBA intervention instead of developer submitting scripts to DBA to run?

Thanks in advance.
  • 1. Re: Deployment tools queries
    rp0428 Guru
    Currently Being Moderated
    >
    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.
  • 2. Re: Deployment tools queries
    jflack Oracle ACE
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points