| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Concealing SQL Loader password from ps -ef
Simplest way is not to enter the password on the same line with the userid. If you wait for SQLPlus to prompt you for the password, it doesn't show up with ps -ef.
On the other hand, doing this in a script is more problematical. Anyone have any examples?
"Thomas,
Kevin" To: Multiple recipients of list ORACLE-L
<Kevin.Thomas <ORACLE-L_at_fatcity.com>
@calanais.com cc:
> Subject: RE: Concealing SQL Loader
password
Sent by: root from ps -ef
10/26/2001
04:40 AM
Please
respond to
ORACLE-L
Jay,
Could you tell me how to do this for SQL*PLUS, I'm too lazy to look now
that
I've found someone that knows ;o)
Cheers,
Kev.
"hit any user to continue"
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com
-----Original Message-----
Sent: 25 October 2001 17:56
To: Multiple recipients of list ORACLE-L
When running Sql Loader from a Unix script is there a way to code it so
that
the password will not be displayed when someone does ps -ef?
I know how to do it for sqlplus, exp and imp but not sql loader.
TIA,
Jay Miller
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: JayMiller_at_TDWaterhouse.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: Kevin.Thomas_at_calanais.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6_at_csc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Oct 26 2001 - 07:46:56 CDT
 |
 |