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 <[EMAIL PROTECTED]>
@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: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas, Kevin
INET: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
