Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hiding export/import passwords

RE: Hiding export/import passwords

From: Juan Miranda <j.miranda_at_sermatica.es>
Date: Fri, 5 May 2006 09:10:39 +0200
Message-Id: <20060505070957.1B7133650@smtp-01.servidoresdns.net>


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-l
Received on Fri May 05 2006 - 02:10:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US