RE: Concealing SQL Loader password from ps -ef

Here's how to do it from a UNIX script for SQL*Plus:

sqlplus -s /nolog<<EOF
connect system/manager
....
....
exit
EOF -----Original Message-----
Sent: Friday, October 26, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenkins, Michael
  INET: Michael.Jenkins_at_Nextel.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).