Unix Technical Forum

deploying plsql code to Oracle via script - secure design?

This is a discussion on deploying plsql code to Oracle via script - secure design? within the HP-UX Operating System forums, part of the Unix Operating Systems category; --> On HPUX 11. Somewhat new to Unix. As a design question.. Say you wanted to write a script that ...


Go Back   Unix Technical Forum > Unix Operating Systems > HP-UX Operating System

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-16-2008, 07:15 PM
jason@cyberpine.com
 
Posts: n/a
Default 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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:39 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com