Unified Auditing for Schema SIUD
1 - How can we audit all schemas in a database for Select, Insert, Update, Delete on all of the tables without specifying each table name?
2 - Is there an automated way to add new tables as they get created?
I was hoping for a less manual way of taking care of all existing and future tables.
Example from the manual:
CREATE AUDIT POLICY dml_pol ACTIONS DELETE on hr.employees, INSERT on hr.employees, UPDATE on hr.employees, ALL on hr.departments;
Thank you