The following database tables store user data:
Database table | Description |
|---|---|
CMS_User | Stores records representing users. |
CMS_UserSettings | Stores the advanced settings of user accounts. |
CMS_UserSite | Stores relationships between users and sites. Each entry indicates that a specific user account is available on a given site. |
CMS_UserCulture | Stores relationships between users and cultures. Each entry indicates that a user may edit the content of documents belonging to a specified culture/language (if the given user has the Editor privilege level). |
CMS_UserMacroIdentity | Security signature used when signing macro expressions. Signatures prevent macros from accessing or displaying data for which the author is not authorized. See Working with macro signatures. |
The following database tables store the data of user roles, permissions and memberships:
Database table | Description |
|---|---|
CMS_Role | Stores records representing roles. |
CMS_UserRole | Stores relationships between users and roles. Each entry indicates that a specific role is assigned to a given user. Also stores the expiration date for roles that are assigned for a limited time period. |
CMS_Membership | Stores records representing memberships. |
CMS_MembershipUser | Stores relationships between users and memberships. Each entry indicates that a user belongs to a specific membership. Also stores the expiration date for roles that are assigned for a limited time period. |
CMS_MembershipRole | Stores relationships between roles and memberships. Each entry indicates that a membership includes a specific role. |
CMS_Permission | Stores the system's permissions. |
CMS_RolePermission | Stores relationships between roles and permissions. Each entry indicates that a role has a specific permission. |
CMS_RoleUIElement | Stores UI personalization settings for roles. |
CMS_RoleApplication | Stores the default application content of the system dashboard for individual roles (the system uses UI elements to represent applications). Users can individually adjust their own dashboard and override these default settings. |
CMS_ACLItem | Stores page-level permissions, and their relationships with users or roles. |
CMS_ACL | Stores relationships between ACL items and individual pages (tree nodes). |