Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center