Database Security Products (MOSC)

MOSC Banner

audit DML on a table not working -- DDL works on schema level

edited May 3, 2024 3:52AM in Database Security Products (MOSC) 2 commentsQuestion

19.15 - Oracle RAC Enterprise Edition - 4 nodes database.

Two audit requirements:

  1. Audit DDL on all tables in a schema(PHX_PROD_TEST). Works
  2. Audit DML on only 1 table in the same schema(PHX_PROD_TEST) DOES NOT work. What am I missing?

A. Audit DDL on the PHX_PROD_TEST schema, i.e.
CREATE TABLE,DROP TABLE,TRUNCATE TABLE,ALTER TABLE, etc.

--Created policy for DDL and it works correctly
CREATE AUDIT POLICY ORA_TABLE_AUDIT ACTIONS
CREATE TABLE,
DROP TABLE,
TRUNCATE TABLE,
ALTER TABLE;

AUDIT POLICY ORA_TABLE_AUDIT by PHX_PROD_TEST;

B. Audit DML on one of the table, PHX_PROD_TEST.DIM_CONFIG. We would like to capture any DML ran by ANY USER on this table.

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