Re: script or program to deploy plsql code while securing DB passwords

jason_at_cyberpine.com wrote:
> Say we had Unix users (developers really) that needed to deploy plsql
> code to an Oracle DB on a remote HP-UX box. But these users would not
> have any security to that remote box or database. Say we did not want
> to surrender users or passwords of the remote box or Database.
>
> Can a script or program be coded on the local box to deploy that code
> without exposing the passwords or any information about the remote
> server or DB?
>
> How exactly would passwords be secured?
>
> Thanks for any help or information.

Jason, how static are the schema's that this plsql code is going to be deployed into?

If you don't need to be able to "dynamically" have different schema's execute different plsql scripts, then there are a couple of ways that I can think of doing this.

Many organizations require some kind of change control group to move code around and to deploy it. That way you create a change control record, follow procedures, get your change approved, prepare scripts/etc, have them reviewed, get the change scheduled, etc.

If you bypass these kinds of controls (not necessarily recommended) then one way would be to put scripts into a directory on the local server, have a script that ftp's them to the remote, have a cron job on the remote job install the scripts.

Is that what you are talking about?

Sure that kind of setup is not hard to do at all. Do you have specific questions about that kind of approach? Received on Wed Jun 29 2005 - 16:07:51 CDT