Re: SQLPLUS login

I AM asking because I need to run sqlplus from a Unix shell script. If the login is wrong, I want sqlplus to terminate and not reprompt for a username/password. How do I do that?

> As far as I know, there is no command line option which makes SQL*Plus
> ask once, and only once, for your username and password.
>
> N.B. If you are on Unix and the reason you are asking is because you
are
> trying to run sqlplus from within a Unix shell script, then there is a
> way to prevent the first two lines of sqlplus input being interpreted
as
> the second and third attempts at the username and password. However, I
> cannot tell from you post whether this would be relevant or not.
>
> In article <7rjqmb$a5e$1_at_nnrp1.deja.com>,
> grsnow_at_my-deja.com wrote:
> > When trying to log into SQLPLUS 8.0.5, if a user enters the wrong
> > username or password, then he/she is prompted twice more for a
correct
> > username/password. Is there a way to not reprompt the user?
> >
> > This is important if sqlplus is run from the command line. If the
> > wrong password is entered I do not want to be reprompted for the
right
> > password. Is there a way arround this reprompting?
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 07:21:24 CDT