Re: "sqlplus orauser/orapasswd@SID" avoid writing passwords in shell scripts
- From: Neil Kodner <nkodner@xxxxxxxxx>
- To: aluoor@xxxxxxxxx
- 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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
