Users, Roles and Permissions
You are looking at an older version of the documentation. The latest version is found here.
SYSADMIN.Roles
This table supplies information on roles.
Column Name | Type | Description |
|---|---|---|
| biginteger | Role ID |
name | string | Role name |
users | string | Usernames in this role |
SYSADMIN.Users
This table supplies information on users.
Column Name | Type | Description |
|---|---|---|
| biginteger | User ID |
name | string | Username |
roles | string | Role names of this user |
creationDate | timestamp | Timestamp when the user data entry was created |
lastModifiedDate | timestamp | Timestamp when the user data entry was last modified |
creator | string | Name of the user who created the user data entry |
modifier | string | Name of the user who last modified the user data entry |
loginAllowed | boolean | Flag to signal if login for this user is allowed or not |
loginAllowed is available since v3.14
SYSADMIN.Permissions
This table supplies information on permissions.
Column Name | Type | Description |
|---|---|---|
| string | Role name |
resource | string | Resource name |
permission | string | Permission string |
creationDate | timestamp | Timestamp when the permission was created |
lastModifiedDate | timestamp | Timestamp when the data source was modified the last time |
creator | string | Name of the user who created the permission |
modifier | string | Name of the user who last modified the permission |