deploying plsql code to Oracle via script - secure design?
On HPUX 11.
Somewhat new to Unix.
As a design question..
Say you wanted to write a script that enable a unix user (from the
command line) on one unix box to deploy code to an Oracle DB located on
another box (don't ask why). Say you wanted that user to only be able
to deploy that code into the database through that script, but never
wanted to give away password to the DB, or unix passwords to the server
which serves the DB. Say you wanted this script to run in real time and
return codes indicating the code compiled and was inserted?
Can this be done securely?
With REMSH? SQLPLUS?
Would it ever be valid to say that any solution that the most secure
way to accomplish is a hold directory a delayed cron or deamon process
that would scan for files as the right user on each side?
Thanks in advance.