Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Disconnecting session from an on logon trigger

Re: Disconnecting session from an on logon trigger

From: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: Mon, 15 Oct 2007 21:58:34 +0200
Message-ID: <4ef2fbf50710151258m437ba7e7tfe0fa2e99730e660@mail.gmail.com>


> I'd like to create an on logon trigger that will prevent the user from
> connecting in certain circumstances. I have one way of doing it which would
> be to issue
> execute immediate ' alter system kill session 'session_id', 'serial#''

Just raise an exception from the logon trigger   raise_application_error (-20001, 'logon denied because ...'); so your bad user will also have a nice error which clearly states the reason why the logon was denied - which is very nice.

-- 
Alberto Dell'Era
"the more you know, the faster you go"
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 15 2007 - 14:58:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US