| 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: How to encrypt Password in Export script file ?
Hi Gurus,
Thanks to those who replied. We feel that Unix account is easily hacked, so we will not implement the method that Rachel mentioned. We will probably "encrypt" the password in another file. Before exporting, we will decrypt the password before passing the password to the export script. Thanks.
Regds,
New Bee
-----Original Message-----
From: Fisher, Julie [mailto:jfishe_at_sandia.gov]
Sent: Thursday, May 31, 2001 11:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to encrypt Password in Export script
file ?
I also did this on all my databases - works very slick.
Julie Fisher
Sandia National Laboratories
Oracle 8i DBA - OCP8i
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator
-----Original Message-----
Sent: May 31, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L
instead of that, I create an account in the database that is
identified
externally (can only run from that server, and does not have
a login
password). You will need a matching Unix account for it, if
the unix account
is "exportacct" then create the database account as
"ops$exportacct"
grant this account create session and exp_full_database
then change your shell script to read userid="/" and run
the script from
the exportacct account
this way you don't need to hardcode a password ANYWHERE
Rachel
>From: "CHAN Chor Ling Catherine (CSC)" <clchan_at_nie.edu.sg>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
>Subject: How to encrypt Password in Export script file ?
>Date: Thu, 31 May 2001 00:50:22 -0800
>
>Hi Unix Gurus,
>
>My daily export file (daily_exp.sh) contains :
>exp userid='system/password' file=file_name.dmp grants=y
rows=y
>constraints=y compress=y full=y inctype=complete
log=file_name.log
>
>The system password is stated clearly in the export script
file. Has anyone
>encrypt/decrypt the system password before passing it as a
variable to the
>export script ? If yes, could I have a copy of your script
? Thanks.
>
>Regds,
>New Bee in Unix
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: CHAN Chor Ling Catherine (CSC)
> INET: clchan_at_nie.edu.sg
>
>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).
Get your FREE download of MSN Explorer at
http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: carmichr_at_hotmail.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: Fisher, Julie
INET: jfishe_at_sandia.gov
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: CHAN Chor Ling Catherine (CSC) INET: clchan_at_nie.edu.sg 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 Thu May 31 2001 - 20:16:30 CDT
 |
 |