Re: Hide SqlPlus username/password in UNIX Script

Erik Ykema wrote:

> 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.
> >
> > --
> > ======================================================================
> >

Dangerous security breach. Why not just use an OPS$ account?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)