Re: "sqlplus orauser/orapasswd_at_SID" avoid writing passwords in shell scripts

From: Neil Kodner <nkodner_at_gmail.com>
Date: Tue, 1 Dec 2009 15:14:52 -0700
Message-ID: <ae2c46ba0912011414o62621e7dsd9f919a2c399d044_at_mail.gmail.com>

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?
>
> cheers
> Sven
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 01 2009 - 16:14:52 CST