[Fwd: Hiding passwords for scripts]

attached mail follows:

WOW, that is a lot of work.....

If the first line of your script is username/password (or SYSTEM/MANAGER for
example), you can invoke SQL*Plus with your script and it will be executed with that
username :

sqlplus @myscript.sql

where myscript.sql contains :
SYSTEM/MANAGER
select count(*) from dba_tables;
exit

Regards,

Marc Mazerolle
InforMaze Technologies

John Strange wrote:

> 1. mkdir /opt/as_long_as_required_directory_to_trail_off_ps_line
> cd /opt/as_long_as_required_directory_to_trail_off_ps_line
> ln -s $ORACLE_HOME/bin/sqlplus sqlplus
>
> modify task from sqlplus use/pw to
> /opt/as_long_as_required_directory_to_trail_off_ps_line/sqlplus
use/id
>
> 2. Try sqlplus @id_passwd.file @script (Cannot remember if this
worked)
>
> 3. Contact oracle. They have a solution which re-spawns the command
with
> a bunch of \Ms or \Rs to hide the id/passwd.
>
> UnixDBA (unixdba_at_aol.com) wrote:
> : I have automated several database tasks which use SQL*Plus to do
their work.
> : However, any user who does a ps on the Unix host can see the
password of the
> : database user while the script is running.
>
> : Does anyone know of an intelligent way to hide the passwords for
automated jobs
> : which use SQL*Plus?
>
> : Please email replies to UnixDBA_at_aol.com. Cheers!
>
> --
> While Alcatel may claim ownership of all my ideas (on or off the job),
> Alcatel does not claim any responsibility for them. Warranty expired
when u
> opened this article and I will not be responsible for its contents or
use. Received on Fri Mar 26 1999 - 14:05:04 CST