mrUserData database
All information about users is stored in the mrUserData database which is created during installation. The database contains a number of tables, three of which are used for managing users and permissions: Users, Roles and UserRoles.
Users
Records in this table determine which users may access UNICOM Intelligence Interviewer - Server Admin.
Fields
UserID
A generated GUID that uniquely identifies the user.
UserName
The user name. A user logs in using this name, and the name is also used in the user administration activities.
Description
A descriptive text entered when the user account is created.
Password
The password for this account. Used when logging in.
PasswordChangeDate
The last time the user's password was changed.
PasswordExpiryDate
Identifies the date on which the password will expire. The date is calculated based on the date the password was last changed (PasswordChangeDate). The password expires after the second expiration notice is generated on the expiration date.
CanChangePassword
Whether the user can change the password. The User Administration activity does not expose this feature.
MustChangePasswordAtNextLogin
If set, the user will be prompted to change his/her password the next time he/she logs in.
AccountIsDisabled
If set, the user will not be allowed to log in.
IsLoggedIn
If set, the user is currently logged in.
Created
The date the account was created.
LastModified
The date the account was last modified.
LastLoggedIn
The date the user last logged in. During synchronization, the field is updated when the following conditions are met:
▪When registering a user for the first time.
▪When uploading a user's case data.
UserPasswordHistory
Records the user password history.
Fields
ID
A unique identifier for the UserPasswordHistory table.
UserID
A generated GUID that uniquely identifies the user.
Password
The password for this account. Used when logging in.
PasswordChangeDate
The last time the user's password was changed.
Roles
Users can be grouped according to the activities or activity features they can use. The records in this table define those groups of roles.
Fields
RoleID
A generated GUID that uniquely identifies the role.
UserName
The role name. This is used in the user administration activities.
Description
A descriptive text entered when the role is created.
Created
The date the role was created.
LastModified
The date the role was last modified.
UserRoles
Records in the table define which users have been assigned to each role.
Fields
UserID
A UserID from the Users table identifying a user who has been assigned to a role
RoleID
A RoleID from the Roles table identifying the role to which the user has been assigned.
Assigned
The date that the user was assigned to the role.
See also