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_at_db1.world @ims_script.sql
exit
- "Freeman, Donald" <dofreeman_at_state.pa.us> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tracy Rahmlow
> 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
> -----------------------------------------------------------------
>
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_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 Tue Jul 20 2004 - 06:36:32 CDT
