Re: Passwords in UNIX process list

From: Eric Worthy <fast_johnnyz_at_yahoo_NO_SPAM_ME.com>
Date: Thu, 7 Feb 2002 13:56:05 -0700
Message-ID: <GRB88.110$Br6.88373@news.uswest.net>

sqlplus -s <<!! > $TEMP_FILE
$ORA_USER/$PASSWD@$ORACLE_SID
set serveroutput on size 1000000
exec some_procedure(some_inputs) or sql statement !!

ret_code=$?
oerr=$(egrep -ic "ora-|pls-|sp2-" $TEMP_FILE) if [[ $ret_code -ne 0 || $oerr -ne 0 ]]
then

    ERROR=SELECT_ERR
    echo "$(date '+%H:%M:%S') Error - Rolling back all changes \n" >> $LOGFILE
    cat $TEMP_FILE >> $LOGFILE
    exit_routine
fi

rm -f $TEMP_FILE

"Craig Silver" <csilver_at_sgsborealis.com> wrote in message news:3C62A549.427126CE_at_sgsborealis.com...
>
> I'm trying to keep database passwords out of the 'ps' listing on a UNIX
> system.
>
> I've use simple redirect scripts in the past, with Sybase and Informix.
> These would just feed the password to the database login process rather
> than including it on the command line ( login/password ).
>
> sqlplus dblogin <<!
> dbpassword
> select ......;
> quit
> !
Received on Thu Feb 07 2002 - 14:56:05 CST