The vdsAdminRole table contains fields to define administrator roles that bundle pre-defined sets of permissions to assign to administrative users.
Columns
Table: vdsAdminRole table columns | Column name | Data type | Primary key | Nullable | Description |
|---|
| vdsTemplateID | varchar(60) | Yes | No | Auto-generated ID to uniquely identify the admin role. |
| vdsName | varchar(255) | No | No | The display name of the admin role. |
| vdsDescription | varchar(1024) | No | Yes | A description of the purpose of the admin role. |
| vdsAdminPrivilegesTemplate | varchar(1024) | No | Yes | The administrative privileges stored as base64-encoded binary data. The data is encrypted with the referred sensitive data key. |
vdsKeyID
| varchar(255) | No | Yes | The sensitive data key used to encrypt the administrative privileges template. |
| vdsCreateTime | timestamp | No | No | The date and time the data record was created. |
| vdsModifyTime | timestamp | No | No | The date and time the data record was last modified. |
| vdsVersion | integer | No | Yes | The current data schema version of the data record. |
Keys
Primary key: (vdsTemplateID)
Foreign keys: (vdsKeyID) references vdsKey (vdsKeyID)
Indexes
Table: vdsAdminRole table indexes | Index name | Included fields |
|---|
| Level 0 (default) |
| vdsadminroleidx | vdsTemplateID |