Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 6219 invoked from network); 5 May 2006 02:10:41 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 5 May 2006 02:10:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DBFE6311D50; Fri, 5 May 2006 03:10:40 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00832-03; Fri, 5 May 2006 03:10:40 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A87E310384; Fri, 5 May 2006 03:10:40 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 05 May 2006 03:10:03 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DABB5311D9E for ; Fri, 5 May 2006 03:10:03 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00764-03 for ; Fri, 5 May 2006 03:10:03 -0400 (EDT) Received: from llsa730-a01.servidoresdns.net (llsa730-a01.servidoresdns.net [82.223.190.24]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9755C310384 for ; Fri, 5 May 2006 03:10:03 -0400 (EDT) Received: from PORTJUAN (cm124158.red.mundo-r.com [213.60.124.158]) by smtp-01.servidoresdns.net (Postfix) with ESMTP id 1B7133650; Fri, 5 May 2006 09:09:57 +0200 (CEST) From: "Juan Miranda" To: , "'oracle-l'" Subject: RE: Hiding export/import passwords Date: Fri, 5 May 2006 09:10:39 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZv1CwVRUiB5bf7T3ee1YcoRk4BHwAPrzjQ In-Reply-To: <1146785913.445a907992423@mail.iinet.net.au> Message-Id: <20060505070957.1B7133650@smtp-01.servidoresdns.net> X-archive-position: 34259 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: j.miranda@sermatica.es Precedence: normal Reply-to: j.miranda@sermatica.es X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.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@freelists.org [mailto:oracle-l-bounce@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 : > 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