Privileges Required to use Tables

To use Tables, you need one of the following:

• scheduler-administrator or redwood-administrator role
• system or partition-level permissions
• object-specific privileges

Using Tables

The following privilege ranks are available on Tables:

• Create - allows you to create a Table on the level the privilege was granted (system, partition), you have no further privileges through this rank, you automatically get All privilege rank on Tables you create.
• View - allows you to view a Table 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 Table on the level the privilege was granted (system, partition).
• Delete - allows you to create, view, and delete a Table on the level the privilege was granted (system, partition).
• All - full control over a Table on the level the privilege was granted (system, partition).

You always need View privileges on the partition of the Table.

Tables 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 Table that references them:

• Application.
• Table Definition.

Built-in Roles

• The scheduler-administrator or redwood-administrator built-in role provides full control over Tables.
• The scheduler-viewer built-in role provides read-only access to Tables.

Creating Tables

You need one of the following privilege ranks to be able to create Tables:

• Create - allows you to create Tables on the level the privilege was granted (system, partition), you have no further privileges through this rank, you automatically get All privilege rank on Tables you create.
• Edit - allows you to create, view, and edit all Tables on the level the privilege was granted (system, partition).
• Delete - allows you to create, view, and delete all Tables on the level the privilege was granted (system, partition).
• All - full control over all Tables on the level the privilege was granted (system, partition).

You also require View privileges on the partition of the Table and Table definition.

Editing Tables

To successfully edit a Table, you must have one the following privileges:

• Edit - privilege rank on the Table, or on Table in its partition or system-wide
• Delete - privilege rank on the Table, or on Table in its partition or system-wide
• All - privilege rank on the Table, or on Table in its partition or system-wide

You also require View privileges on the partition of the Table and Table definition.

Tables 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 Table that references them:

• Application.

See Also

• Privileges Required to use Applications
• Privileges Required to use Objects