Re: How to Forbid sqlplus connecting to ORACLE

afaik since you can write a sql-plus like utility in pro*c fairly easily then there is no real way except deletion or removal of sql*plus from the client.

since you could write a logon trigger based on the application name and disconnect, but since you can call the appname anything then you might want to go the other way and restrict connection .

Doesn't the new 'identified by an ID-server' option in connect help with this ?
"Grant" <goddabao_at_yahoo.com> wrote in message news:bcp9hl$t5_at_netnews.proxy.lucent.com...
> OOPS, That's not what I want!
> If I stop the listner, my Client application will not work, they are
> connected to the Oracle Server via ODBC. In fact, I just want the user can
> only using our Client Program instead of using sqlplus to operate the DB
> directly.
>
> <Kenneth Koenraadt> wrote in message
> news:3ef02148.2921160_at_news.inet.tele.dk...
> > On Wed, 18 Jun 2003 15:50:16 +0800, "Grant" <goddabao_at_yahoo.com>
> > wrote:
>
> > Hi Grant,
> >
> > Odd request, I hope you are aware that Svrmgrl is gone with 9i ?!
> >
> > Anyway, if you only want connection with Svrmgrl from the Host, simply
> >
> > 1) Turn off the listener for the instance, thus forcing users to
> > connect from the host only (by setting ORACLE_SID)
> >
> > 2) Remove sqlplus from the host.
> >
> > .....Think twice !
> >
> > - Kenneth Koenraadt
>
>
>
Received on Wed Jun 18 2003 - 04:57:43 CDT