Sure. Create the database userid so that it is authenticated externally
(Identfied externally).
Then the userid can log in via SQL*Plus using a "/" instead of a userid or
password. The OS userid should be a controlled account so that everyone and
his grandmother cannot log into it.
If it is a matter of encryption, turn on encryption by adding the
encryption login parameter to the sqlnet.ora file.
RWB
============================================================================================================
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
============================================================================================================
[EMAIL PROTECTED]
ox.net To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: how to hide oracle password
from a unix ps -ef | grep?
ity.com
01/16/2004
12:04 PM
Please respond
to ORACLE-L
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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
