Re: SQLPlus scripts in Unix

From: Brian Gallagher <briang_at_iona.com>
Date: Fri, 4 Jun 1999 12:00:09 +0100
Message-ID: <7j8bq1$kje$1@bvweb.dublin.iona.ie>

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 - 06:00:09 CDT