Purpose
The information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS view displays the number of failed login attempts of different users.
Note
This view is introduced since OceanBase Database V3.2.1.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| USERHOST | varchar(261) | NO | The username and host information of the user that failed to log in, in the format of <user_name>@<hostname or ip address>. |
| FAILED_ATTEMPTS | bigint(20) | NO | The number of failed login attempts. |