PASSWORD_AUDITOR
Stores information about individual users and their password information.
Stores information about individual users and their password information. This table also indicates if users are using hash authentication, which is the associated security algorithm.
| Column Name | Data Type | Description |
|---|---|---|
USER_ID |
INTEGER | Unique ID for the user. |
USER_NAME |
VARCHAR | Name of the user. |
ACCTEXPIRED |
BOOLEAN |
Indicates if the user’s password expires. 'f' indicates that it does not expire. 't' indicates that it does expire. |
SECURITY_ALGORITHM |
VARCHAR |
User-level security algorithm for hash authentication. Valid values:
|
SYSTEM_SECURITY_ALGORITHM |
VARCHAR |
System-level security algorithm for hash authentication. Valid values:
|
EFFECTIVE_SECURITY_ALGORITHM |
VARCHAR |
The resulting security algorithm, depending on the values of SECURTY_ALGORITHM and SYSTEM_SECURITY_ALGORITHM. |
CURRENT_SECURITY_ALGORITHM |
VARCHAR |
The security algorithm used to hash the user's current password. This can differ from the EFFECTIVE_SECURITY_ALGORITHM if a user hasn't reset their password since a change in the EFFECTIVE_SECURITY_ALGORITHM. Valid values:
|