Re: Hiding the password in UNIX?

From: chansis .earthlink.net <chansis_at_>
Date: 2000/05/16
Message-ID: <x21U4.196$7V2.9424@newsread2.prod.itd.earthlink.net>#1/1

Another way of doing this, if you execute it in a cron type format, is to have a script like this:

#/bin/sh
su - oracle
sqlplus <<EOF
system/system

This will get into the correct account, start sqlplus, then feed in the system/system as a command line parameter, but it won't be visable when you do a "ps -ef|grep sqlplus"

HTH; JH

<buckeye714_at_my-deja.com> wrote in message news:8fpkuq$va3$1_at_nnrp1.deja.com...
> Don't enter the password at the command line. SQLplus will prompt you
> for it. It will not show up in the process listing.
>
> HTH,
> Patrick
>
>
> In article <8fpfhh$75tq$1_at_node17.cwnet.frontiernet.net>,
> "Stephen W Ruiz" <scruiz_at_frontiernet.net> wrote:
> > Does anyone know a good way to let users use sqlplus without entering
their
> > username/password on the command line. It shows up when you grep for
> > sqlplus. How do you get arround this issue. In our Sybase
environments we
> > echo a parameter to isql, but that did not work with Oracle for some
reason.
> > Thanks for your response.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Tue May 16 2000 - 00:00:00 CDT