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
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
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
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
> -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
"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
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]
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