1. Oracle SQL Firewall User's Guide
  2. Appendix: SQL Firewall Database Views and DBMS Package
  3. SQL Firewall Database Views
  4. DBA_SQL_FIREWALL_STATUS

A.10 DBA_SQL_FIREWALL_STATUS

DBA_SQL_FIREWALL_STATUS displays the status of SQL Firewall.

Column Datatype NULL Description

STATUS

VARCHAR2(8)

SQL Firewall status (ENABLED or DISABLED)

STATUS_UPDATED_ON

TIMESTAMP(6) WITH TIME ZONE

NOT NULL

Date and time of the most recent SQL Firewall status change

EXCLUDE_JOBS

VARCHAR2(12)

Indicates whether the SQL Firewall will capture or enforce allow-lists for database connections and SQL executions of Oracle scheduler job sessions (Y) or not (N)

Note:

This view is available starting with Oracle Database 23ai.