RE: restrict connections to some instances in RAC
- From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Feb 2004 09:06:23 -0500
Thanks. I use dbms_job to spawn a proc to kill the session.=20
The connection continues normally when I raise unhandled exception in =
the
logon trigger.
A trace file gets generated that shows that some problems took place =
and
that the database connection is continuing with its connection.
Actually I found that the a lot of things get ignored or behave =
differently
in logon triggers, and it seems to me that it's designed this way.
Did you test this "unhandled exception" in logon triggers? What Oracle
release?
Thanks
Waleed
-----Original Message-----
From: Tanel P=F5der [mailto:tanel.poder.003@xxxxxxx]
Sent: Friday, February 13, 2004 5:10 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: restrict connections to some instances in RAC
Hi, are you sure you are actually killing the session, because you =
can't
kill your own session with alter system kill session. But anyway, any
unhandled exception in logon trigger will prevent users without =
'administer
database trigger' from logging in.
One more thing you could do to direct clients to correct instances, is =
using
different service names for different client types and assigning the =
service
names to relevant instances. But the logon trigger should remain there, =
just
in case (if you aren't doing excessive logons all the time).
Tanel.
----- Original Message -----
From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, February 13, 2004 7:01 AM
Subject: restrict connections to some instances in RAC
> Is there a clean way to restrict connections for certain users to =
specific
> instances in RAC environments?
>
> What I have now is a logon trigger that kills the session.
>
> Thanks
>
> Waleed
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
