Re: SQLPlus scripts in Unix

From: John Higgins <JH33378_at_deere.com>
Date: Fri, 04 Jun 1999 19:42:49 -0500
Message-ID: <37587289.B0033663@deere.com>

Why not just do this:
sqlplus -s <<EOF
system/realpassword

-
-
-

EOF Then no password is visible to ps -ef.

Brian Gallagher wrote:

> A very good question - i've wondered about that myself. One quick and dirty
> solution is to have separate scripts
>
> sqlplus system/realpassword <<EOF
> alter user system identified by manager;
> EOF
>
> then in your script you can run
> sqlplus system/manager <<EOF
> alter user system identified by realpassword;
> -
> -
> -
> -
> -
> EOF
>
> for the duration of the long script it will appear by ps -ef that
> you have connected as manager
>
> still i'm sure there's a better easier way. You could write an expect
> script but this would be overkill
>
> hope this helps
>
> regards
> brian
>
> Brian Peasland wrote in message ...
> >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
> >
> >
Received on Fri Jun 04 1999 - 19:42:49 CDT