29.12.13.5 The temporary_account_locks Table

The temporary_account_locks table lists the users with temporarily locked accounts.

The temporary_account_locks table has these columns:

• USER

  The user name of the account used.

• HOST

  The host name of the account used.

• LOCKED

  Whether the account is currently temporarily locked. The value is YES or NO.

• FAILED_LOGIN_ATTEMPTS

  The number of login attempts, as defined in the password locking policy.

• REMAINING_LOGIN_ATTEMPTS

  The number of login attempts remaining before the account is locked.

• PASSWORD_LOCK_TIME

  Lock time, in days, as defined in the password locking policy.

• LOCKED_SINCE

  The date the account was locked. NULL if the account is not locked.

• LOCKED_UNTIL

  The date the account is locked until. NULL if the account is not locked.