Check for Logon Triggers in Oracle

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%’;

Leave a Reply