Re: connect userid/password script

From: Daryl Peh Boon Chai <darylpeh_at_ncb.gov.sg>
Date: 1996/09/09
Message-ID: <510hat$4a3_at_ncb.gov.sg>#1/1


You can store the password in a password file. Then in your sqlplus command, redirect in the password file, eg : sqlplus userid _at_sqlfilename < passwordfile This way, the password file can be kept in a safe place where only the CRON id can access. It is safer than keeping in the sqlscript.

Daryl

Marek Wiechula and Sheila Plant (sparemgw_at_batelco.com.bh) wrote:
: 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

--
------------------------------------------------------------------ 

PEH BOON CHAI , DARYL                                    \,`/ /
IT ANALYST                                              _)..  `_
NATIONAL COMPUTER BOARD            	               ( __  -\	
PRIME MINISTER'S OFFICE                                    '`.
COMPUTER INFORMATION SYSTEMS DEPARTMENT                   < \>
email : darylpeh_at_ncb.gov.sg                               _||_~
Tel   : 65-3238098   Fax : 65-3239026                     
------------------------------------------------------------------
Received on Mon Sep 09 1996 - 00:00:00 CEST

Original text of this message