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 AI Database 26ai.