USER_ROLES

This table displays information to join the USERS and ROLES tables.

Important! Loftware Enterprise SP Auditing Schema (LOFTAUDIT) tables are read-only. Modifications to these tables could cause errors and prevent Loftware Enterprise SP from functioning.

Note: If you are using Loftware Cloud Enterprise SP, Loftware Cloud Operations may have assigned unique names for the reporting schema and the auditing schema for your Loftware Enterprise SP 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 User Role. Key: Primary Key
MODIFIED	Timestamp	The time when this User Role was last modified.
CREATED	Timestamp	The time when this User Role was created.
CREATED_ISSUER	Number	The ID of the User that created this User Role. Refer to the LOFTREPORTS.R_USERS table.
LAST_UPDATED_ISSUER	Number	The ID of the User that last modified this User Role. Refer to the LOFTREPORTS.R_USERS table.
AUDIT_ACTION	String	The type of audit action performed on this User Role. CREATE INSERT UPDATE DELETE
AUDIT_DATE	Timestamp	The date and time when the audit action was performed on this User Role.
OBJECT_ID	Number	Loftware use only.
ROLE_ID	Number	The ID of this Role in the ROLES table.
USER_ID	Number	The ID of this User in the USERS table.