Re: How to Forbid sqlplus connecting to ORACLE

On Wed, 18 Jun 2003 15:50:16 +0800, "Grant" <goddabao_at_yahoo.com> wrote:

>Hi,
>
>Does anyone know how to forbid sqlplus connecting to ORACLE Server?
>I don't want somebody using my DB Server via sqlplus in Client, and I will
>only permit the user using svrmgrl on the Host.
>
>The ORACLE Server version is 8.1.7 (another is 8.1.5), running on Solaris.
>
>Thanks
>Best Regards,
>
>Grant
>
>

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