Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus scripts in Unix

Re: SQLPlus scripts in Unix

From: Uri Margalit <uri_at_hypernix.co.il>
Date: Mon, 7 Jun 1999 22:41:28 +0200
Message-ID: <7jh77v$3oo$1@news.netvision.net.il>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US