Re: sqlplus execute cmd

On Wed, 27 Nov 2002, martin.doherty_at_elcaro.moc wrote:
> Watch out with this sqlplus $username/$password stuff ... that
> command line puts your username and password in plain sight on
> the list of Unix process (ps -ef | grep sqlplus) for any Unix
> user to see... your script should be able to embed the password
> at least in the Here document to provide a tad more security.

Yes, and along those lines, I to set a shell variable as the sqlplus login parameters, something like,

#!/bin/ksh

##
# This file has the login variables set. . .authfile

LOGIN="sqlplus $username/$password@$instance"

$LOGIN << EOF
SQL stuff here
;
EOF

-- 
Galen Boyer