[MDEV-31186] Provide information about a user via an information schema table - Jira

XML

Word

Printable

Details

Type: Task
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Fix Version/s: None
Component/s: Authentication and Privilege System, Information Schema
Labels:
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

Stalled

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

Activity

People

Assignee:: Unassigned

Reporter:: Ralf Gebhardt

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-05-04 07:28

Updated:: 2024-03-10 11:25

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.