Database Administration (MOSC)

MOSC Banner

Auditing DDL (specifically DROP) regardless of ownership

edited Jul 30, 2024 2:37PM in Database Administration (MOSC) 3 commentsAnswered

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.

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