CREATE OR REPLACE TRIGGER ddl_event_audit

  AFTER CREATE OR ALTER OR DROP ON SCHEMA

BEGIN

  INSERT INTO ddl_audit_log (operation, object_name, user_name, timestamp)

  VALUES (ORA_DICT_OBJ_TYPE, ORA_DICT_OBJ_NAME, USER, SYSDATE);

END;