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

Category: DatabaseSQL


One comment

Leave a Reply

Article by: Shadab Mohammad