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