Database Administration (MOSC)

MOSC Banner

unified auditiong did not pickup ALL STATEMENTS in pdb

Hi all,

  1. 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center