Query to check if there is any logon triggers defined for your database. Logon trigger is a trigger which fires an event based on login to a schema/user. It can be used either for auditing purpose or some other event.
select * from dba_triggers where triggering_event like ‘%LOGON%’;
One comment
All these years later, still useful. Thanks!