PASSWORD_AUDITOR

Stores information about user accounts, account expirations, and password hashing algorithms.

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:

  • 'NONE' (Default. Algorithm specified by SYSTEM_SECURITY_ALGORITHM is used.)

  • 'SHA512'

  • 'MD5'

SYSTEM_SECURITY_ALGORITHM VARCHAR

System-level security algorithm for hash authentication.

Valid values:

  • 'SHA512' (Default)

  • 'MD5'

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:

  • 'NONE' (Default. Algorithm specified by SYSTEM_SECURITY_ALGORITHM is used.)

  • 'SHA512'

  • 'MD5'