Database Administration (MOSC)

MOSC Banner

Unified Auditing question about creating auditing policies ,19C

Hi All,

I want to create an policy which audits all the database objects for the statements:

DDL Statements: CREATE, ALTER, DROP,REPLACE,TRUNCATE

DML Statements: INSERT,UPDATE,DELETE

Do I have to specify this for each database object sperately , for example:

CREATE TABLE. CREATE TRIGGER, CREATE ANY PROCEDURE ? Or is there a more simple way to do this ?

Hope someone can point me in the right direction.


Regards,

Reyaz

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