Re: SQLPLUS login

From: <grsnow_at_my-deja.com>
Date: Wed, 15 Sep 1999 13:02:43 GMT
Message-ID: <7ro5d9$bih$1@nnrp1.deja.com>

I'm interested in using this method. Do you know the syntax on how to test if a user can connect?

> There's no way. The workaround is to check if a user can connect
> prior to executing sqlplus. F.e. there's a handy Oracle's oiconnect
> utility, it
> takes a connection specifier and returns 0 if it can connect and 1 if
not.
>
> Regards,
> Karen Abgarian.
>
> 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. Received on Wed Sep 15 1999 - 08:02:43 CDT