Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus scripts in Unix
Why not use a specific user that has been create with identified by
externaly ?
<nainm_at_my-deja.com> wrote in message news:7j62jf$gbf$1_at_nnrp1.deja.com...
> Try this cool(!!) approach:
> 1. create a file in a safe location(only you've access to that) by name
> <<username>>. write only the password in that file
> 2. create a system variable in the profile by name say userpasswd and
> assign:
> userpasswd = 'cat <<safe_dir>>/<<username>>' ; export userpasswd
>
> 3. read this variable in the cron script
>
> nainm
>
>
>
>
> In article <u$H76yWr#GA.293_at_cpmsnbbsa02>,
> "Brian Peasland" <peasland_at_email.msn.com> wrote:
> > 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?
> >
> > Thanks in advance!
> > Brian Peasland
> > peasland_at_msn.com
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 07 1999 - 15:41:28 CDT
![]() |
![]() |