[MDEV-30045] settable message to notify end-user N-days prior the password get expired Created: 2022-11-20  Updated: 2023-05-04  Resolved: 2023-05-04

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Yakov Kushnirsky Assignee: Unassigned
Resolution: Won't Do Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-31186 Provide information about a user via ... Open
relates to MDEV-32218 message to notify end-user N-days pri... Open

 Description   

There is a feature request to implement settable notification message that will notify end-user N-days before the password get expired,

For example:
warning: the password will expire within N days



 Comments   
Comment by Ralf Gebhardt [ 2022-11-29 ]

YK, from my point of view an application should implement such a notification itself, but the server should provide an easy way to query the current password lifetime. Currently the only way would be via the mysql.global_priv table, which is not the preferred option.

Comment by Yakov Kushnirsky [ 2022-12-12 ]

Per this customer's update - the message in the mariadb command line client will suffice.
I like your idea of providing an easy way to query the password lifetime (to facilitate for app devs further implementation) so leave this JIRA open.

As well as open new one for the command line client - TOOLS-56

Comment by Sergei Golubchik [ 2023-01-04 ]

I'd say, we need a table in information schema with information about users (or accounts). With information, like

  • authentication plugin
  • password expiration
  • locked or not
  • resource limits
  • SSL
    etc
Generated at Thu Feb 08 10:13:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.