audit DML on a table not working -- DDL works on schema level
19.15 - Oracle RAC Enterprise Edition - 4 nodes database.
Two audit requirements:
- Audit DDL on all tables in a schema(PHX_PROD_TEST). Works
- 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.