Shell Scripts/PW Security

I have a series of database performance tuning scripts that we would like to run from a particular machine against remote instances. If we were running these online we could issue the command:

sqlplus username/password_at_remote_sqlservice @sqlscript_to_run

We would like for these scripts to run inside crontab entries, and for rather obvious security reasons we can't embed the usernames and passwords inside the shell script and remote os authentication would not be allowed by our security group. We are aware that if we copy each of the scripts to the remote machine we can run them using the ops$ accounts, but would like to avoid the overhead of maintaining all these copies of the scripts in separate locations and of redeveloping the driver portion of the scripts in OpenVMS, NT-4.l, etc.

If you have any ideas that you have used to accomplish something like this please post a reply to this news group or mail.

Thanks,

John Hough Received on Mon Nov 25 1996 - 00:00:00 CST