Try creating a user with only 'full export' privileges

-----Original Message-----
From: Stephen Price
[mailto:oracledba-ezmlmshield-x63626023.[Email address protected]
Sent: Friday, March 30, 2007 1:44 PM
To: LazyDBA Discussion
Subject: Automate Export using exp without exposing system password

Is there a way of automating the exp command without hard coding the
system password? I am using 10gR2 on Linux RHEL4 and through trial and
error have not found a way to do this without hard coding the system
password in a PAR file or exposing the password to anyone able to
execute a simple ps command.



Cheers,

Stephen



Stephen Price
Oracle Database Administrator
Compusearch Software Systems, Inc.





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page