Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Forbid sqlplus connecting to ORACLE
Actually Tom [http://asktom.oacle.com] came out with a hole in this method.
If you rename the Executable name and Run it. U go in with sqlplus.
-- HTH Regards, Ganesh R "James Williams" <willjamu_at_mindspring.com> wrote in message news:3ef259be.7274405_at_nntp.mindspring.com...Received on Thu Jun 19 2003 - 22:12:07 CDT
> 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
> >
> >
>