Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Detailed information about a user account, like
- authentication plugin
- password expiration
- locked or not
- resource limits
- SSL
is only stored in mysql system tables. Providing such information in an information schema table can be useful in some cases.
- For a DBA it would be easier to find all account related information in one table to track down issues a user might report
- A user can check in how many days his password expires
- an application could implement a notification for a password to expire
A standard user should only see information about his user account, a DBA for all users.
This Feature request is MDEV-30045
Attachments
Issue Links
- relates to
-
MDEV-23729 INFORMATION_SCHEMA Table info. about user locked due to max_password_errors
- Closed
-
MDEV-30045 settable message to notify end-user N-days prior the password get expired
- Closed
-
MDEV-32649 Add INFORMATION_SCHEMA Table with user related details
- Open