RE: Restrict login for a particular user to be only from particul ar m achines

Any user with ADMINISTER DATABASE TRIGGER privilege can log on even if the logon trigger raises an error.  

Look into udump and you'll see Oracle complaining about the trigger's exception there.  

Tanel.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Haddon
Sent: Thursday, September 14, 2006 09:25 To: JApplewhite_at_austinisd.org
Cc: oracle-l_at_freelists.org
Subject: Re: Restrict login for a particular user to be only from particul ar m achines

The trigger is working but when you raise the application error the insert gets rolled back.

The only way we were able to accomplish the logging of a failed login was to use the

declare

    pragma autonomous_transaction;
begin

This way the insert gets committed when you raise the application error exception

Hope this helps

Mike

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