Re: sqlload password not on command line?

From: Robert Feinman <robertdfeinman_at_worldnet.att.net>
Date: Thu, 24 Jun 1999 20:56:16 -0400
Message-ID: <3772D3B0.6FD70559_at_worldnet.att.net>


This may not work.
Some versions of ps will show command line options anyway. One of Unix's dirty secrets is that users with shell access can see more than they should be able to.
Run sqlload from a client machine (PC) using sqlnet, perhaps. Of course if you have lots of data it may be slow... Kenneth C Stahl wrote:

> Put this in a shell script:
>
> #!/bin/ksh
> sqlload control=myctl.ctl <<-sqlEOF
> scott/tiger
> sqlEOF
>
> Rick Osterberg wrote:
>
> > Is there any easy way to specify a user/password_at_database parameter for
> > SQL*Loader (sqlload) that's _not_ on the command line? I want to run a
> > SQL*Loader routine automatically, and don't want the username/password on
> > the command line, because then it will show up in the 'ps' process
> > listing. This is on Digital Unix/Compaq Tru64 Unix 4.0x, and Oracle 8.
> > Thoughts?
> >
> > -Rick
> >
> > --
> > +--------------------------------------------------------------------------+
> > | Rick Osterberg osterber_at_fas.harvard.edu |
> > +--------------------------------------------------------------------------+

--
Robert Feinman, Ph.D                  Database Doctor
robertdfeinman_at_worldnet.att.net
Received on Fri Jun 25 1999 - 02:56:16 CEST

Original text of this message