[MDEV-31186] Provide information about a user via an information schema table Created: 2023-05-04  Updated: 2023-05-04

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System, Information Schema
Fix Version/s: None

Type: Task Priority: Major
Reporter: Ralf Gebhardt Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-30045 settable message to notify end-user N... Closed

 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
Generated at Thu Feb 08 10:21:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.