Re: help:hide/encrypt an oracle password in a shell script

From: Jens Wartenberg <wartenberg_id_at_ibm.net>
Date: 1997/03/21
Message-ID: <33328F23.7D27@ibm.net>#1/1

Hi,
Consider using OPS$ passwords. That way you dont need password's for Oracle itself. You need to be on a system with fair/safe password functions (like Unix/AIX).

Regards

Jens Wartenberg

---

  WARTENBERG                        |    People
  Industri Data                     |    that make a difference
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  IBM RS/6000 - IBM AIX - Oracle | For industrial needs - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  Aavaenget 2, Aavang               |    Email: wartenberg_id_at_ibm.net
  DK - 4320  Lejre, Denmark         |    Fax:   +45 46 48 12 94 
-----------------------------------------------------------------------

wrote:
>
> I would appreciate if somebody can help me out
> with the following issue:
>
> I wrote a shell program that invokes Oracle's SQL*PLUS
> (eg. myid/password @sql_script.sql), but the problem
> is that ps -ef| grep sql will display the user and the
> oracle password. How can I hide the password?
>
> myid and password are passed as positional
> parameters, but I am thinking of changing it to interactive mode
> (menu-driven) so myid and password would be entered from a menu as follows:
>
> Oracle id: myid
> Password : ********
>
> the the script should invoke SQL*PLUS:
> myid/******** @sql_script.sql
>
> and ps -ef|grep sql hopefully will not show password,
>
> Thank you.
> Santiago Cabezas
> Oracle DBA
> santiago.cabezas_at_cplc.com
> Carolina Power&Light co.
Received on Fri Mar 21 1997 - 00:00:00 CST