Re: "sqlplus orauser/orapasswd_at_SID" avoid writing passwords in shell scripts
Date: Wed, 2 Dec 2009 08:10:39 -0600
Message-ID: <OF51E7D520.3119AD3B-ON86257680.004D6FEE-86257680.004DE041_at_Rotometrics.com>
We have a file on the server that is locked down. Then, from a shell script run though the cron, we launch sqlplus.
APPSPWD=`cat /path/to/file`
sqlplus -s apps/$APPSPWD <<END
Sven Aluoor <aluoor_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org
12/01/2009 03:41 PM
Please respond to
aluoor_at_gmail.com
To
oracle-l_at_freelists.org
cc
Subject
"sqlplus orauser/orapasswd_at_SID" avoid writing passwords in shell scripts
Hi folks
I have here a Solaris box where i need to setup cronjob (with session to remote DB). On the remote DB i have no access, expect limited user via sqlplus.
How to avoid putting passwords in shell scripts?
cheers
Sven
--
http://www.freelists.org/webpage/oracle-l
Sharon Kovac | RotoMetrics
Phone: +1 636 587 3600 | Fax: +1 636 587 3701800 Howerton Lane | Eureka, MO 63025 | USA
www.rotometrics.com
This e-mail message is intended only for the personal use of the recipient(s) named above. This message is confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the sender immediately by e-mail and delete the original message.
.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 02 2009 - 08:10:39 CST