Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help:hide/encrypt an oracle password in a shell script
<Unknow wrote in article <3147cd$d2bb.3b_at_NEWS>...
> I would appreciate if somebody can help me out
> with the following issue:
>
> I wrote a shell program that invokes Oracle's SQL*PLUS
> (eg. myid/password @sql_script.sql), but the problem
> is that ps -ef| grep sql will display the user and the
> oracle password. How can I hide the password?
>
<snip>
>
> Thank you.
Use a HERE script:
sqlplus <<'HERE'
myid
password
@script.sql
HERE
Gert
Received on Fri Mar 21 1997 - 00:00:00 CST