Re: SQLPLUS login

I'm not sure if I understood your question well. Did you mean how to do it in a shell script? Then try this (ksh):

oiconnect $1
if [ $? = 0 ]; then
  echo "can connect";
else
  echo "cannot connect";
fi

Regards,
Karen Abgarian.

grsnow_at_my-deja.com wrote:

> 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 - 09:10:08 CDT