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:[EMAIL PROTECTED]]
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)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
>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: [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).
_________________________________________________________________
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: [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: Fisher, Julie
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: CHAN Chor Ling Catherine (CSC)
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).
RE: How to encrypt Password in Export script file ?
CHAN Chor Ling Catherine (CSC) Thu, 31 May 2001 18:16:30 -0700
- How to encrypt Password in Export script fi... CHAN Chor Ling Catherine (CSC)
- Re: How to encrypt Password in Export ... Connor McDonald
- Re: How to encrypt Password in Export ... Rachel Carmichael
- RE: How to encrypt Password in Export ... Deshpande, Kirti
- RE: How to encrypt Password in Export ... Fisher, Julie
- RE: How to encrypt Password in Export ... Nirmal Kumar Muthu Kumaran
- Re: How to encrypt Password in Export ... Stephane Faroult
- Re: How to encrypt Password in Export ... Mohammad Rafiq
- CHAN Chor Ling Catherine (CSC)
