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_SQL_LOGS

A.9 DBA_SQL_FIREWALL_SQL_LOGS

DBA_SQL_FIREWALL_SQL_LOGS displays information about SQL logs for SQL Firewall.

Column Datatype NULL Description

COMMAND_TYPE

VARCHAR2(64)

Type of SQL command

SQL_SIGNATURE

VARCHAR2(64)

SQL signature

SQL_TEXT

CLOB

SQL text

ACCESSED_OBJECTS

CLOB

List of accessed objects

CHARSET

VARCHAR2(64)

Character set of the SQL text

Note:

This view is available starting with Oracle Database 23ai.