> 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
