Re: audit

Posted by ErmanArslansOracleBlog on Nov 25, 2022; 10:40am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/audit-tp11262p11266.html

Do you have the required audit config for auditing those truncate command?
I mean, did you issued "AUDIT TABLE" commands while configuring your audit mechanism?
If so, there should be a record for that op in your audit log.. Otherwise; you won't see any audit records there.

FACT:

 "AUDIT TABLE" audits the CREATE TABLE, TRUNCATE TABLE, COMMENT ON TABLE, ALTER TABLE,  DROP TABLE and DELETE [FROM] TABLE statements.

AUDIT TABLE audit option would capture the truncate table and drop table commands executed, even by the object owner.

Reference: How to Audit Truncate Table command? (Doc ID 2202398.1)