Privileges Required to Use Triggers

To use Triggers, you need one of the following:

scheduler-administrator or redwood-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 or redwood-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