Re: Hiding password from ps - Need better solution

Try the following:

sqlplus -s <<!
username/password
_at_command arguments

!

I use a shellscript to start a sql report via a cronjob. In that shellscript I use the above mentioned SQL*Plus call. And it works!

The only disadvantage of this solution is that the username/password is hardwired in that start shellscript but it is not visible for the "ps". If you want to use a log file use the following call:

sqlplus -s <<! >> logfile.log 2>&1
username/password
_at_command arguments

!

I hope, that this will help you. Received on Wed Apr 10 1996 - 00:00:00 CEST