ROLES
This table displays a log of the changes made to roles. In Spectrum, role-based permissions are assigned to a role and inherited by users who are members of a group to which that role is assigned or by users to whom the role is directly assigned.
Important! Spectrum Auditing Schema (LOFTAUDIT) tables are read-only. Modifications to these tables could cause errors and prevent Spectrum from functioning.
Note: If you are using Loftware Spectrum Cloud, Loftware Cloud Operations may have assigned unique names for the reporting schema and the auditing schema for your Spectrum instance. Contact Loftware Cloud Operations for details.
Note: All timestamps are relative to the time on the database server.
| Column Name | Type | Description |
|---|---|---|
|
ID |
Number |
The internal identification number of a Role. Key: Primary Key |
|
MODIFIED |
Timestamp |
The time when this Role was last modified. |
|
CREATED |
Timestamp |
The time when this Role was created. |
|
CREATED_ISSUER |
Number |
The ID of the User that created this Role. Refer to the LOFTREPORTS.R_USERS table. |
|
LAST_UPDATED_ISSUER |
Number |
The ID of the User that last modified this Role. Refer to the LOFTREPORTS.R_USERS table. |
|
AUDIT_ACTION |
String |
The type of audit action performed on this Role. CREATE INSERT UPDATE DELETE |
|
AUDIT_DATE |
Timestamp |
The date and time when the audit action was performed on this Role. |
|
OBJECT_ID |
Number |
Loftware use only. |
|
SYSTEM |
String |
Whether the Role is incapable of being deleted. True: The Role is built-in and may not be deleted by a user. False: The Role may be deleted by a user with appropriate permissions. Update: The Role may be modified but not deleted by a user. |
|
DENIES |
Number |
The bitmask value representing the default permissions for this Role that are denied to the Groups and Users for which permissions are not configured. For more information, see Bitmask Values. |
|
GRANTS |
Number |
The bitmask value representing the default permissions for this Role that are granted to the Groups and Users for which permissions are not configured. For more information, see Bitmask Values. |
|
CASED_NAME |
String |
The name of this Role. |
|
PARENT_ID |
Number |
The ID of the parent Folder for this Role, or NULL if this is the root Folder. Key: Foreign Key, join with ROLES |
|
PARTITION_TIER1 |
Number |
Not used. |
|
PARTITION_TIER2 |
Number |
Not used. |
|
PARTITION_TIER3 |
Number |
Not used. |
|
DESCRIPTION |
String |
The user-defined description of this Role. |
more