Oracle 22.214.171.124 on AIX
I recently noticed an entry in DBA_AUDIT_TRAIL for a table with select, insert ,update ,delete audited by access.
The table belongs to another user and the audited user has all DML privileges.
The action columns was Delete and the priv_used column was select any table - The transactionid was 000000000 and I am wondering about this entry.
If we had a delete on this table then the priv_used should be delete any table - Instead it was a select any table - No records were deleted since the transactionid is 0. Any idea why this entry was generated(The DML which caused this entry) .