Re: Hide Password in SQL Plus

You can use externally identified account (ops$) or do the following

sqlplus /nolog -- start sqlplus but do not logon connect username/password -- logon

In article <3238C8B9.7537_at_wwa.com>, Alexander Lyakhovetsky <alexl_at_wwa.com> wrote:

> We are using sqlplus in shell scripts. In order to connect to a
> database, we have to pass connect string but password becomes visibale
> if you run ps command. Is there any way to hide password from ps
> command?
>
> Here is a couple of lines from our script.
>
> CONNECT=dbid/password
> sqlplus $CONNECT
>
> Thanks, Alex
>
> alexl_at_wwa.com
 

-- 
Dave Erwin
Lockheed Martin Missiles & Space
Email: derwin_at_lmsc.lockheed.com

The opinions expressed are those of the author and not necessarily those of the Lockheed Martin Corporation.