RE: how to hide oracle password from a unix ps -ef | grep?

-----Original Message-----
From: Tanel Poder [mailto:tanel.poder.003@mail.ee]
Sent: Friday, January 16, 2004 12:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: how to hide oracle password from a unix ps -ef | grep?

Few ideas:

 

1) sqlplus /nolog

   connect user/pwd@host

 

2) . $HOME/.orapwd

   sqlplus user/$ORAPWD@host

 

(.orapwd script has to set environment variable ORAPWD to the password)

 

3) sqlplus system@host < $HOME/.orapwd

 

(.orapwd must contain one line, the password)

 

Tanel.

 

----- Original Message -----

From: Ryan

To: Multiple recipients of list ORACLE-L

Sent: Friday, January 16, 2004 8:04 PM

Subject: how to hide oracle password from a unix ps -ef | grep?

Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bellow, Bambi
  INET: bbellow_at_chi.navtech.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).