2 Replies Latest reply: Mar 12, 2013 7:30 AM by jflack RSS

    Deployment tools queries

    user2429896
      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
          >
          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
            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.