1. Oracle SQL Firewall User's Guide
  2. Oracle SQL Firewall Data Dictionary Views and Example Queries
  3. Query to Find a User's Oracle SQL Firewall Violations

4.4 Query to Find a User's Oracle SQL Firewall Violations

The DBA_SQL_FIREWALL_VIOLATIONS data dictionary view shows the Oracle SQL Firewall violations that a user has committed.

For example:

SELECT SQL_TEXT, OCCURRED_AT, FIREWALL_ACTION FROM DBA_SQL_FIREWALL_VIOLATIONS WHERE USERNAME = 'HR';
 
SQL_TEXT                           OCCURRED_AT                         FIREWALL_ACTION
---------------------------------- ----------------------------------  –--------------
SELECT COUNT(*) FROM HR.EMPLOYEES  12-OCT-23 10.30.02.238383 AM +00:00 BLOCKED

Related Topics