How do I turn on audit trail for specific statement insert?
First, you have to set your AUDIT_TRAIL initialization parameter to DB and bounce your database. Then issue a statement similar to the following:
AUDIT INSERT ON schema.table;
The audit records will be placed in SYS.AUD$ and can be viewed through DBA_AUDIT_* views.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.