RoleChangeHistoryAccess (version 19.11.0)
This table stores change history access level overrides for viewing audit history. An entry in this table overrides the default capabilities defined for a data source on a single user access role.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CanAccessFlag | 19.11.0 | Number(1) | This value overrides a role's default access capability. Valid values: 0 = Cannot Access,1 = Can Access. Defaults to 0. Required. |
ChangeHistorySettingsID | 19.11.0 | Number(10) | Internal number for the associated ChangeHistorySettings record. |
RoleDefID | 19.11.0 | Number(19) | Internal number for the associated RoleDef record. Indexed. |
RoleChangeHistoryAccessID | 19.11.0 | Number(19) | Sequential number generated by the application, but uniqueness in the table is guaranteed. Indexed. Required. |
| WhenCreated | 19.11.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
| WhenModified | 19.11.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 19.11.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
| WhoModified | 19.11.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |