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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.