On 9/13/06, Baumgartel, Paul <paul.baumgartel@xxxxxxxxxxxxxxxxx> wrote:
However, I'm now stymied in a simple test case: the following SYS trigger is firing, but no error appears on login.
This is documented behavior.
You cannot use a trigger to prevent a DBA account from logging on.
Any logon initiated by a user that has been granted the ADMINISTER DATABASE TRIGGER privilege will bypass a logon trigger.
SYS has this privilege and can therefor logon to the database regardless of what happens in the trigger.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist