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: Database connection from remote server

RE: Database connection from remote server

From: Patamalla, Chaya <chaya.patamalla_at_usaa.com>
Date: Mon, 19 Jul 2004 13:45:39 -0500
Message-ID: <41E69449FCCCCD4E9BB81E7122685CE908D6A19C@ex03.eagle.usaa.com>


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_at_usaa.com=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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Dick Sent: Monday, July 19, 2004 1:39 PM
To: oracle-l_at_freelists.org
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_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=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_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
-----------------------------------------------------------------
----------------------------------------------------------------
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:42:27 CDT

Original text of this message

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