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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s