Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to hide oracle password from a unix ps -ef | grep?
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)
reginald.w.bailey_at_jpmorgan.com
baileyre_at_us.ibm.com
ryan.gaffuri_at_c ox.net To: ORACLE-L_at_fatcity.com Sent by: cc: ml-errors_at_fatc 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: Reginald.W.Bailey_at_jpmorgan.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-LReceived on Fri Jan 16 2004 - 12:29:26 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |