Privileges Required to Use Tables
To use Tables, you need one of the following:
scheduler-administrator
orredwood-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:
Built-in Roles
- The
scheduler-administrator
orredwood-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: