Re: SQLPlus scripts in Unix

From: <nainm_at_my-deja.com>
Date: Thu, 03 Jun 1999 14:14:15 GMT
Message-ID: <7j62jf$gbf$1@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 Thu Jun 03 1999 - 09:14:15 CDT