PASSWORD_AUDITOR

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:

  • 'NONE' (Default. System-level security algorithm is used.)
  • 'MD5'
  • 'SHA512' 
SYSTEM_SECURITY_ALGORITHM
 VARCHAR

System-level security algorithm for hash authentication.

Default value:

'NONE' (Uses MD5 algorithm.)

Valid values:

  • 'MD5'
  • 'SHA512' 
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:

  • 'NONE' (Default. System-level security algorithm is used.)
  • 'SHA512'
  • 'MD5'