Re: connect userid/password script

From: BEERYR <Ron.Beery_at_DaytonOH.ATTGIS.COM>
Date: 1996/09/10
Message-ID: <DxJ1LG.1JI_at_ranger.daytonoh.ncr.com>#1/1


Another way to hide the userid/password from ps when using sqlplus is: "sqlplus /nolog _at_my.sql" and put the userid/password within the sql script.

>==========Marek Wiechula and Sheila Plant, 9/7/96==========
>
>jpjones_at_ wrote:
>>
 

>> Question:
>> We have a script that kicks off an export that is fed a
 userid/password
>> combination. Executing a ps -ef on our Unix system shows the actual
>> userid/password combination the export process is using.
>>
>> How can we prevent the password from showing up along with the system
>> process information?
>>
>
>
>I have the same problem. With the export jobs I embed the
 user/password
>in the parameter file as other commentators have suggested. But I also
>run SQL*Plus jobs. In these cases I put the user/password into the
>~.sql script and use a relatively public sign on with no more than
>CREATE SESSION capability to make the UNIX level connection. The
>user/password inside the script are not echoed to the ps -fe output.
>
>Marek

Ron Beery
NCR
"Everything is computerized. What could possibly go wrong?" Received on Tue Sep 10 1996 - 00:00:00 CEST

Original text of this message