Re: Hide Password in SQL Plus

From: Alvaro H. Buitrago Giraldo <albuitra_at_calvin.univalle.edu.co>
Date: 1996/09/18
Message-ID: <51o2d8$b4h_at_sunsite.univalle.edu.co>#1/1


Parris Geiser (parris_at_duart.esp.bellcore.com) wrote:

: 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?

: > CONNECT=dbid/password
: > sqlplus $CONNECT

Have you tried with identified by OS??
We have our database users identified externally, and in the init file have a line with:
os_authent_prefix = ""
So, when the users connect, they use sqlplus / In this form, only the user in the OS can connect to the database.

Bye

--
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   ~   Alvaro Hernan Buitrago Giraldo                 ~
   ~   Lo peor que le pudo pasar a sistemas           ~
   ~   Cuando estes en medio de una gran sombra       ~
   ~   Es por que hay una gran luz cerca              ~
   ~   e-mail: albuitra_at_calvin.univalle.edu.co        ~
   ~   http://calvin.univalle.edu.co/~albuitra        ~
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Wed Sep 18 1996 - 00:00:00 CEST

Original text of this message