UserRoleProperties: Exact Online User Role Properties
read only
- Catalog:
ExactOnlineREST - Schema:
Views - Label: User Role Properties
Properties of user roles.
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 432 |
| Full scan rows per minute | 50,300 |
| Point query rows per minute | 138 |
The result can be cached on the client.
Table Columns
The columns of the table UserRoleProperties are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CHANGESDATA |
bit |
Changes |
|||
ISACCOUNTMANAGEMENT |
bit |
Is |
|||
ISCOMPANYMANAGEMENT |
bit |
Is |
|||
ISPAYROLLMANAGEMENT |
bit |
Is |
|||
ISUSERMANAGEMENT |
bit |
Is |
|||
ROLEDESCRIPTION |
varchar2 |
Role |
|||
ROLEID |
number |
RoleId |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: