Track History of User Role Assignments and Permissions

You can manage the history of permissions, user, and role assignments through history tables. These history tables keep track of all changes to the appropriate tables. When changes are made to the table, the changes are captured by triggers and copied to the history tables.

The following table describes the table name and history table name for users, role assignments, and permissions:

History Tables
Name Table History Table
Users 
MEMBER
 
MEMBERHISTORY
Role Assignments 
ROLEASSIGNMENT
 
ROLEASSIGHISTORY
Permissions 
RESOURCEACL
 
RESOURCEACLHISTORY