You'd know Jared only likes it if it comes Perl'd!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx] Sent: Tuesday, July 20, 2004 11:56 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Database connection from remote server > we like to put passwords in the scritp env then execute something = like=20 >=20 > . /etc/profile > . ~/.profile > # next line exports the passwords > . $HOME/bin/orapw=20 > echo $imspw | sqlplus -S ims@xxxxxxxxx @ims_script.sql > exit I personally prefer using the password server in the PDBA toolkit. www.oreilly.com/catalog/oracleperl :) Now with encrypted config files. ( though that feature hasn't yet made its way to the O'Reilly site) Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------