| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: restrict connections to some instances in RAC
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_at_mail.ee]
Sent: Friday, February 13, 2004 5:10 PM
To: oracle-l_at_freelists.org
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.
> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Feb 17 2004 - 08:06:23 CST
 |
 |