Re: Hide SqlPlus username/password in UNIX Script

From: Erik Ykema <Erik.SIHTEVOMER.Ykema_at_xs4all.nl>
Date: Thu, 1 May 2003 21:04:55 +0200
Message-ID: <3eb16fda$0$49099$e4fe514c@news.xs4all.nl>

You could also define an environment variable, like export MMCONNECT=user/password_at_instance
and then connect to sql*plus in the unix-script with sqlplus $MMCONNECT @script.
By executing

set | grep MMCONNECT
a logged-in user can see the value of MMCONNECT. Also trusted oracle (sqlplus /) might help out, the acces control is the shifted from sql*plus access restriction to unix. Good Luck,
Erik Ykema

"Ubiquitous" <weberm_at_polaris.net> wrote in message news:Tbucnc2T7KxwPy2jXTWcpA_at_comcast.com...
> In article <d6052717.0304230844.2382873d_at_posting.google.com>,
> gilgantic_at_yahoo.com wrote:
>
> >I want to hide the username and password when I run SqlPlus on in a UNIX
> >script.How do I do this?
>
> I never tried it, but about using a stored PL/SQL procedure containing
> the call which invokes SQL*LOADER? That way you just invoke the stored
> procedure without showing the password.
>
> --
> ======================================================================
> ISLAM: Winning the hearts and minds of the world, one bomb at a time.
>
Received on Thu May 01 2003 - 14:04:55 CDT