Re: How to encrypt Password in Export script file ?

a) Changet the script to print "system/password" | exp full=y ... so no-one can see it with a 'ps' b) chmod 700 daily_exp.sh so no-one except the (presumably) oracle account can see the script hth connor --- "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> wrote: > Hi Unix Gurus, > > M

Re: How to encrypt Password in Export script file ?

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 t

RE: How to encrypt Password in Export script file ?

Hi, Pl look into the parfile option for export/import. You can keep all your export/import command line parameters in there, including userid/password. Parfile (with chmod 700) is only accessible to the owner, so no one else can see what is in it. And when you run exp/imp nothing from the parfile

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

RE: How to encrypt Password in Export script file ?

> -Original Message- > From: Fisher, Julie [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 31, 2001 6: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 databas

Re: How to encrypt Password in Export script file ?

"CHAN Chor Ling Catherine (CSC)" wrote: > > 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 e

Re: How to encrypt Password in Export script file ?

put your userid and password and all other parameters in parfile and run. exp parfile=abc.parfile It will hide your password on unix level. your password file should be readable by you only... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]

RE: How to encrypt Password in Export script file ?

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