Re: "sqlplus orauser/orapasswd_at_SID" avoid writing passwords in shell scripts
Date: Tue, 1 Dec 2009 15:14:52 -0700
A number of ways - If you're connecting as the DBA, you can just sqlplus /nolog
connect / as sysdba
Another way would be to create an externally identified user.
A few more methods involve having your shell script look up the passwords from a secured file, or storing the passwords as environment variables. I don't think the environment-variable route will work under cron, however.
On Tue, Dec 1, 2009 at 2:40 PM, Sven Aluoor <aluoor_at_gmail.com> wrote:
> 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?