Re: How to Forbid sqlplus connecting to ORACLE

From: Grant <goddabao_at_yahoo.com>
Date: Wed, 18 Jun 2003 16:56:35 +0800
Message-ID: <bcp9hl$t5@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 - 03:56:35 CDT