Auditing DDL (specifically DROP) regardless of ownership
Good morning,
We're looking for a way to add auditing to our audit log for DROP events regardless of the ownership of the object in question (not SYS objects) or the user dropping the object (non-SYS).
We would want this auditing to work for all non-sys users and all objects outside of the SYS schema.
Is there a straightforward way to do this?
Again, what we really need is audit of the DDL statement DROP only for ALL non-sys objects when not dropped by SYS regardless of schema (outside SYS). This would include VIEWS, SEQUENCES, PROCEDURES, MVS, TRIGGERS, FUNCTIONS, TABLES - the works.