Administering Triggers

To administer triggers, a user must have Database Manager security privilege. Essbase monitors and potentially activates triggers during the following activities:

Essbase does not activate triggers during a database restructure.

  To create, change, display, and delete triggers, use a tool:

Tool

Topic

Location

Administration Services

Creating Triggers

Editing Triggers

Viewing Triggers

Enabling and Disabling Triggers

Viewing Trigger Spool Files

Deleting Triggers

Oracle Essbase Administration Services Online Help

MaxL

create trigger

create or replace trigger

alter trigger

display trigger

drop trigger

Oracle Essbase Technical Reference

You can see information on enabled and disabled triggers in the application log file when you start Essbase Server.