Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hiding export/import passwords
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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_at_acxiom.com>:
> 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 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 05 2006 - 02:10:39 CDT