Re: Hide Password in SQL Plus

Chris Jones wrote:
>
> "Brian M. Biggs" <bbiggs_at_cincom.com> writes:
> > Dave Erwin wrote:
> > > sqlplus /nolog -- start sqlplus but do not logon
> > > connect username/password -- logon
> >
> > I used to do this on VMS, but under UNIX it doesn't look like SQL*Plus
> > supports the /nolog parameter. Anyone else seen this?
>
> It works for me. The /nolog option is a generic part of SQL*Plus in
> command line environments.

I found my problem. We had a LOGIN.SQL that was getting run every time I logged into SQL*Plus. The first thing it did was set the prompt to the name of the current database by querying GLOBAL_NAME. If I ran SQL*Plus with /nolog, I never logged onto a database, and the LOGIN.SQL got errors, which screwed up any other commands or scripts I tried to run. I stopped running the LOGIN.SQL script and the /nolog works fine now.

Thanks for everyone's comments.

Regards,
Brian

-- 
Brian M. Biggs				mailto:bbiggs_at_cincom.com
Cincom Systems, Inc.			voice: (513) 677-7661
http://www.cincom.com/