Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help:hide/encrypt an oracle password in a shell script

Re: help:hide/encrypt an oracle password in a shell script

From: Gert Rijs <gem_at_wirehub.nl>
Date: 1997/03/21
Message-ID: <01bc3583$358185c0$0100007f@gertrijs>#1/1

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US