Re: SQLPlus scripts in Unix

I echo the password from another file. This will not show the password with ps -ef (on HPUX anyway)

echo $(passwordfile) | sqlplus username_at_instanceid @sqlscript

Julio Negueruela wrote:

> Brian Peasland escribió:
> >
> > I have an easy question. I want to set up a cron job to run an SQLPlus
> > script at certain times. My dilemma is how to hide the userid/password. If I
> > store that info in the script, I'm afraid others might be able to "see" it.
> > How can I automate some script processing and still be able to maintain
> > security. How do you do it?
>
> Whay I usually do is:
>
> chmod 700 <scrpit_name>
>
> This way only the owner is able to see it.
>
> Hope this help.
> --
> Julio Negueruela
> DBA Servicio Informático
> Universidad de La Rioja - Spain
> Telf: 941-299179 Fax: 941- 299180
> mailto:julio.negueruela_at_si.unirioja.es
Received on Mon Jun 07 1999 - 12:49:02 CDT