Re: Hiding password from ps - Need better solution

badri_at_cc.gatech.edu (badri) wrote:

>Hi:
 

> We have an ORACLE 7.2 database on Dynix/ptx 4.1.2. I wanted
>to hide the username and password from "ps" command.

I once had the same problem. Some people suggested a solution which helped me:

use a file redirection to pass your params to SQL*PLUS, it's a bit crude but it works (you won`t see your arguments trhough)

Ex.: the contents of the param.dat file is:

"scott/tiger_at_t:host:instance a b c"

Use the following command:

sqlplus < param.dat

If you do a ps -ef all you`ll see is "sql*plus < param.dat"

                Hope this helps
Guy Dallaire
Groupe DMR Inc.
dallaire_at_megatoon.com

Please reply by e-mail also

P.S. My opinions are my own and do not reflect those of my employer Received on Fri Apr 12 1996 - 00:00:00 CEST