Privileges Required to use Table Definitions

To use Table Definitions, you need one of the following:

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

• Application.
• Table.

Built-in Roles

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

• Application.

See Also

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