RE: Hiding export/import passwords
- From: "Juan Miranda" <j.miranda@xxxxxxxxxxxx>
- To: <dbvision@xxxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 May 2006 09:10:39 +0200
Windows:
exp '/ as sysdba' file=%expfile%.dmp log=%expfile%.log consistent=yes full=y
statistics=none
Unix:
exp \'/ as sysdba\' file ....
if you launch from cron:
su - oracle -c "exp \'/ as sysdba\' file=...."
-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de Nuno Souto
Enviado el: viernes, 05 de mayo de 2006 1:39
Para: oracle-l
Asunto: Re: Hiding export/import passwords
Quoting Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>:
> Anyone have suggestions or a technique to code exp/imp so password is
> not stored on server for cron job?
>
ops$ is not terribly secure, so we just code the password
in the parameter file, dedicate a OS user to this process
and make all files -and directories - readable only by that
user.
--
Cheers
Nuno Souto
from sunny Sydney
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
