I have a table 'class' owned by the schema 'test' and I need to audit all operations on the particular table.
audit INSERT,UPDATE,DELETE ON test.class -- will this be sufficient to do the trick?
Should I enable any other kind of Fine grained auditing to capture all the details.
Oracle12c/RHEL - I have set audit trail to DB. And sys operations to true.
Inputs needed here