Re: How to Forbid sqlplus connecting to ORACLE

From: James Williams <willjamu_at_mindspring.com>
Date: Fri, 20 Jun 2003 00:49:17 GMT
Message-ID: <3ef259be.7274405@nntp.mindspring.com>

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

You can use Logon Triggers if your program's use DBMS_APPLICATION_INFO to register the app in the program field of v$session. That way you can stop anything that comes through that does not match your program. You also need logic to allow the Oracle processes to work.

>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
>
>
Received on Thu Jun 19 2003 - 19:49:17 CDT