RE: Database connection from remote server
- From: Raj Jamadagni <rjamya@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 20 Jul 2004 04:39:59 -0700 (PDT)
we like to put passwords in the scritp env then execute something like
. /etc/profile
. ~/.profile
# next line exports the passwords
. $HOME/bin/orapw
echo $imspw | sqlplus -S ims@xxxxxxxxx @ims_script.sql
exit
--- "Freeman, Donald" <dofreeman@xxxxxxxxxxx> wrote:
> Put the userid and password in a file and restrict read access to the =
> user running the job. Pass the contents of the file into the script. I =
> don't have the examples handy and haven't worked in unix in several =
> years but that's a secure way of doing it.
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tracy Rahmlow
> 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=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@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
> -----------------------------------------------------------------
>
=====
Best Regards
Raj
---------------------------------------------------------
select mandatory_disclaimer from company_requirements;
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
