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

How about enabling OS_AUTHENTICATION?

On Thu, 2 Sep 1999 12:58:36 GMT, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

>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

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email