Re: how to hide oracle password from a unix ps -ef

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Fri, 16 Jan 2004 10:34:45 -0800
Message-ID: <F001.005DD08A.20040116103445@fatcity.com>

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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).

Received on Fri Jan 16 2004 - 12:34:45 CST

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