Re: How to avoid display of password when script executes SQLPLUS / SQLLDR

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 2 Sep 1999 12:58:36 GMT
Message-ID: <37CE747C.FECBB68@edcmail.cr.usgs.gov>

We store the password in a file. We then issue a CHMOD 400 PASSWDFILE so that only the Oracle Unix user can read the password file. Then when calling SQL*Plus (or others), we re-direct the password. For example:

SQLPLUS username @scriptname < PASSWDFILE

When someone does a 'ps' they won't see the password.

HTH,
Brian

Paul Q wrote:
>
> You have to have a restricted ps version.
>
> goei wrote in message <37CDA7A8.18BB_at_wxs.nl>...
> >Hi all,
> >
> >I don't know if i'm in the right group and if not sorry.
> >
> >My problem is the following:
> >
> >Is it possible to execute a Unix Script including calling SQLPLUS with
> >its parameters (Database-name and Password) but without having the
> >password displayed when one uses the Unix PS (Processor Statistics?)
> >Command? Maybe there are other Unix Commands which shows Password too.
> >
> >The same applies for calling SQLLDR.
> >
> >
> >Thank you all very much.
> >
> >G. Oei
Received on Thu Sep 02 1999 - 07:58:36 CDT