In the Users application, you create and manage user records.
User records contain user names, passwords, and security profiles
that determine the applications, options, and data to which a user
can access.
When you create a user record, you also must create a person record.
A user record can be associated with only one person record. A person record can be associated
with only one user record. You can associate a labor record and a user record with the same person
record.
By default, when you use an application server for authentication, the
directory manages user creation. You can set properties to let user creation be performed directly
in the system. The settings of these properties result in certain features being enabled or disabled
in the system.
The following table describes the database tables that are updated
when you create a user record.
Table 1. Database tables that are
updated for user records
Database table |
Description |
MAXUSER |
- Updates with new user data.
|
PERSON |
- Updates with new person data (if a person record needs to be created
for the new user).
|
PHONE |
- Stores all user phone number information, including home phone
number, work phone number, cell phone number, pager number, and so
on.
- Indicates primary phone number.
|
EMAIL |
- Stores all user email addresses, including home email address,
work email address, and alternate email addresses
- Indicates primary email address
|
GROUPUSER |
- Updates the relationship between security groups and the user.
|
USERPURGL |
- Stores the default purchasing general ledger account for the new
user.
- This data is optional.
|
GRPREASSIGNAUTH |
- Stores the name of the user as a person with authority to add
users to a security group
- This data is optional.
|
MAXUSERSTATUS |
- Shows the status for the user, such as active or blocked.
- Stores the history of user status changes.
|
PASSWORDHISTORY |
- Stores the current password for the user and the history of password
changes.
- If password duration is enabled, data in the password column is
encrypted.
|