Re: Disconnecting session from an on logon trigger

Just raise an exception on the logon trigger, and the logon fails. If you want to be nice to the user you can give them a nice error message.

RAISE_APPLICATION_ERROR(-20001,'Logon failed because XXXXX');

ANd if you make a mistake in your trigger logic and raise the exception for all logons, i.e. you end up with a database that no-one can logon to (not that I've ever done this :-), you can logon as SYS as logon triggers don't fire for SYS

--
http://www.freelists.org/webpage/oracle-l