unified auditiong did not pickup ALL STATEMENTS in pdb
Hi all,
- I have unified audit on, CONN SYS@PDB1 as sysdba
SQL> select * from v$option where parameter='Unified Auditing';
PARAMETER VALUE CON_ID
Unified Auditing TRUE 0
2. CONNECT test@pdb1 «— connect to a user in pdb
SQL> AUDIT ALL STATEMENTS IN SESSION CURRENT BY ACCESS container=current;
SQL> SELECT 1 FROM DUAL;
3. Then CONN SYS@PDB1 and checked, the SELECT statement is NOT captured in the unified_audit_trail table, only the AUDIT all statement command is captured.
SQL> select dbusername, event_timestamp, sql_text, audit_option, target_user, current_user, unified_audit_policies from unified_audit_trail where event_timestamp > trunc(sysdate)