RE: Database connection from remote server

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 19 Jul 2004 14:39:19 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C536@25exch1.vicorpower.vicr.com>

Tracy,

        We have a similar problem, for which I came up with a "solution". We = created a program that uses a couple of environment variables & some = database tables to determine if you can have the password and then use = that is the call to SQR, SQL*Plus, etc. If your interested I can share = easily.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Tracy Rahmlow [mailto:tracy.rahmlow_at_aexp.com] Sent: Monday, July 19, 2004 2:32 PM
To: oracle-l_at_freelists.org
Subject: Database connection from remote server

I need to execute a sql script on unix, which will connect to a remote=20 oracle database. What can I do to prevent hard-coding the oracle = password=20
within the script?
American Express made the following
 annotations on 07/19/2004 11:31:22 AM

-------------------------------------------------------------------------=

---

*************************************************************************=
*****
     "This message and any attachments are solely for the intended =

recipient and may contain confidential or privileged information. If you = are not the intended recipient, any disclosure, copying, use, or = distribution of the information included in this message and any = attachments is prohibited. If you have received this communication in = error, please notify us by reply e-mail and immediately and permanently = delete this message and any attachments. Thank you."

*************************************************************************=

---

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 19 2004 - 13:36:22 CDT