Re: sqlplus and unix - hidden user and password

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 11 Jan 2000 15:22:54 GMT
Message-ID: <85fhse$prb$2@news.seed.net.tw>

Sigrid Staudte <sigrid.staudte_at_gmx.de> wrote in message news:85dc2l$i5m$1_at_ernie.haupt.de...
> Hi...
>
> I'm starting sqlplus from a unix shell in a shell script with the command
>
> sqlplus user/password<<EOF
> ...
> sql-statements
> ...
> exit;
> EOF
>
> The database is running on the unix server. When I start the command
>
> ps -ef |grep user
>
> then the complete command sqlplus user/password is displayed. So can
> anybody find out the username and password.
> Is there a possibility to hidden user and password? Is there another
> way to start sqlplus in a shell script, so that nobody can seen the
> user and password with the ps command.

Try:

sqlplus /nolog <<EOF
connect user/password_at_host
...
SQL statements or start script
...
exit;
EOF Received on Tue Jan 11 2000 - 09:22:54 CST