PASSWORD_AUDITOR
Stores information about user accounts, account expirations, and password hashing algorithms.
| 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. For details, see Password hashing 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:
|