Dick, I have a similar situation. Can you share it with me as well. =20 Thanks Chaya Patamalla=20 I/T Database Administrator=20 email=A0 chaya.patamalla@xxxxxxxx=A0=A0=A0=A0=A0=A0=20 --"The opinions expressed herein are solely the author's and are not = necessarily the opinion of USAA."=A0--=A0=A0=A0=A0=A0=A0=A0=A0=A0=20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Goulet, Dick Sent: Monday, July 19, 2004 1:39 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Database connection from remote server Tracy, We have a similar problem, for which I came up with a "solution". We = =3D created a program that uses a couple of environment variables & some =3D database tables to determine if you can have the password and then use = =3D that is the call to SQR, SQL*Plus, etc. If your interested I can share = =3D easily. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Tracy Rahmlow [mailto:tracy.rahmlow@xxxxxxxx] Sent: Monday, July 19, 2004 2:32 PM To: oracle-l@xxxxxxxxxxxxx Subject: Database connection from remote server I need to execute a sql script on unix, which will connect to a = remote=3D20 oracle database. What can I do to prevent hard-coding the oracle =3D password=3D20 within the script? American Express made the following annotations on 07/19/2004 11:31:22 AM -------------------------------------------------------------------------= =3D ----- *************************************************************************= =3D ***** "This message and any attachments are solely for the intended =3D recipient and may contain confidential or privileged information. If you = =3D are not the intended recipient, any disclosure, copying, use, or =3D distribution of the information included in this message and any =3D attachments is prohibited. If you have received this communication in = =3D error, please notify us by reply e-mail and immediately and permanently = =3D delete this message and any attachments. Thank you." *************************************************************************= =3D ***** =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D =3D3D=3D3D=3D3D ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------