Privileges Required to Use Table Definitions
To use Table Definitions, you need one of the following:
scheduler-administrator
orredwood-administrator
role- system or partition-level permissions
- object-specific privileges
Using Table Definitions
The following privilege ranks are available on Table Definitions:
- Create - allows you to create a Table Definition on the level the privilege was granted (system, partition), you have no further privileges through this rank, you automatically get All privilege rank on Table Definitions you create.
- View - allows you to view a Table Definition 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 Definition on the level the privilege was granted (system, partition).
- Delete - allows you to create, view, and delete a Table Definition on the level the privilege was granted (system, partition).
- All - full control over a Table Definition on the level the privilege was granted (system, partition).
You always need View privileges on the partition of the Table Definition.
Table Definitions 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 Definition that references them:
Built-in Roles
- The
scheduler-administrator
orredwood-administrator
built-in role provides full control over Table Definitions. - The
scheduler-viewer
built-in role provides read-only access to Table Definitions.
Creating Table Definitions
You need one of the following privilege ranks to be able to create Table Definitions:
- Create - allows you to create Table Definitions on the level the privilege was granted (system, partition), you have no further privileges through this rank, you automatically get All privilege rank on Table Definitions you create.
- Edit - allows you to create, view, and edit all Table Definitions on the level the privilege was granted (system, partition).
- Delete - allows you to create, view, and delete all Table Definitions on the level the privilege was granted (system, partition).
- All - full control over all Table Definitions on the level the privilege was granted (system, partition).
You also require View privileges on the partition of the Table Definition.
Editing Table Definitions
To successfully edit a Table Definition, you must have one the following privileges:
- Edit - privilege rank on the Table Definition, or on Table Definition in its partition or system-wide
- Delete - privilege rank on the Table Definition, or on Table Definition in its partition or system-wide
- All - privilege rank on the Table Definition, or on Table Definition in its partition or system-wide
You also require View privileges on the partition of the Table Definition.
Table Definitions 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 Definition that references them: