Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
With MDEV-23729 users should be able to query which users a blocked due to max_password_errors. This feature request is to enhance this feature having a table like "blocked_accounts" in the information schema which stores all currently blocked (and maybe also locked) accounts and an information why they are blocked. Possible reasons are:
max-password-errors reached
max_connect_errors reached
MAX_CONNECTIONS_PER_HOUR reached (ER_USER_LIMIT_REACHED)
MAX_USER_CONNECTIONS reached (ER_TOO_MANY_USER_CONNECTIONS)
password expired
account locked
secure_auth set => mysql_old_password is used
The table content should only be accessible for a user with privilege CONNECTION ADMIN
Attachments
Issue Links
- relates to
-
MDEV-27205 MariaDB user last login time details at DB level
- Stalled
-
MDEV-30045 settable message to notify end-user N-days prior the password get expired
- Closed
-
MDEV-31186 Provide information about a user via an information schema table
- Open
-
MDEV-32218 message to notify end-user N-days prior the password get expired
- Closed
-
MDEV-23729 INFORMATION_SCHEMA Table info. about user locked due to max_password_errors
- Closed