Privileges Required to use Triggers
To use Triggers, you need one of the following:
scheduler-administrator
orredwood-administrator
role- system or partition-level permissions
- object-specific privileges
Using Triggers
The following privilege ranks are available on Triggers:
- Create - allows you to create a Trigger on the level the privilege was granted (system, partition), you have no further privileges through this rank, you automatically get All privilege rank on Triggers you create.
- View - allows you to view a Trigger on the level the privilege was granted (system, partition), you have no further privileges through this rank.
- Edit - allows you to create, view, and edit a Trigger on the level the privilege was granted (system, partition).
- Delete - allows you to create, view, and delete a Trigger on the level the privilege was granted (system, partition).
- All - full control over a Trigger on the level the privilege was granted (system, partition).
You always need View privileges on the partition of the Trigger.
Triggers can reference the following objects, you need at least View privileges on these objects as well as their partition(s) when you want to create/edit/delete a Trigger that references them:
Built-in Roles
- The
scheduler-administrator
orredwood-administrator
built-in role provides full control over Triggers. - The
scheduler-viewer
built-in role provides read-only access to Triggers.
Creating Triggers
You need one of the following privilege ranks to be able to create Triggers:
- Create - allows you to create Triggers on the level the privilege was granted (system, partition), you have no further privileges through this rank, you automatically get All privilege rank on Triggers you create.
- Edit - allows you to create, view, and edit all Triggers on the level the privilege was granted (system, partition).
- Delete - allows you to create, view, and delete all Triggers on the level the privilege was granted (system, partition).
- All - full control over all Triggers on the level the privilege was granted (system, partition).
You also require View privileges on the partition of the Trigger.
Editing Triggers
To successfully edit a Trigger, you must have one the following privileges:
- Edit - privilege rank on the Trigger, or on Trigger in its partition or system-wide
- Delete - privilege rank on the Trigger, or on Trigger in its partition or system-wide
- All - privilege rank on the Trigger, or on Trigger in its partition or system-wide
You also require View privileges on the partition of the Trigger.
Triggers can reference the following objects, you need at least View privileges on these objects as well as their partition(s) when you want to create/edit/delete a Trigger that references them: