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