Database Security Products (MOSC)

MOSC Banner

Unified audit on a "alter trigger XX disable"

edited Apr 12, 2017 9:48AM in Database Security Products (MOSC) 5 commentsAnswered ✓

Hi!

I have created the following audit policy:

CREATE AUDIT POLICY uapol_dev_ddl_actions

ACTIONS    CREATE TABLE, CREATE INDEX, CREATE SEQUENCE,

            CREATE VIEW, CREATE TRIGGER,CREATE MATERIALIZED VIEW LOG,

            CREATE MATERIALIZED VIEW, CREATE TYPE, CREATE TYPE BODY,

            CREATE FUNCTION, CREATE PACKAGE, CREATE PACKAGE BODY,

            CREATE SCHEMA SYNONYM, CREATE AUDIT POLICY, CREATE JAVA,

            CREATE LIBRARY, ALTER INDEX, ALTER SEQUENCE, ALTER TABLE,

            ALTER SESSION, ALTER TRIGGER, ALTER MATERIALIZED VIEW LOG,

            ALTER MATERIALIZED VIEW, ALTER TYPE, ALTER TYPE BODY,

            ALTER VIEW, ALTER FUNCTION, ALTER PACKAGE, ALTER PACKAGE BODY,

            ALTER JAVA, ALTER SYNONYM, ALTER AUDIT POLICY, DROP INDEX,

            DROP TABLE, DROP SEQUENCE, DROP VIEW, DROP TRIGGER,

Tagged:

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