Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

DBA_AUDIT_TRAIL.SQL_TEXT Column Is Null

User_MZYLDAug 15 2023

Why DBA_AUDIT_TRAIL.SQL_TEXT column is null even though select statment is audited?

Please check statements outputs below and help out with idea.

The statement below shows no SQL_TEXT recorded.

SQL> SELECT COUNT(*)
FROM DBA_AUDIT_TRAIL
WHERE ACTION_NAME = 'SELECT'
AND SQL_TEXT IS NOT NULL;

COUNT(*)
----------
0

Although, the statement shows that select statement is enabled for auditing.

SQL> SELECT AUDIT_OPTION,SUCCESS,FAILURE FROM DBA_STMT_AUDIT_OPTS WHERE AUDIT_OPTION LIKE '%SELECT%'
2 ;

AUDIT_OPTION SUCCESS FAILURE
---------------------------------------- ---------- ----------
SELECT ANY TABLE BY ACCESS BY ACCESS

This post has been answered by User_3ABCE on Aug 15 2023
Jump to Answer
Comments
Post Details
Added on Aug 15 2023
3 comments
195 views