Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30045

settable message to notify end-user N-days prior the password get expired

Details

    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

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-31186 Provide information about a user via an information schema table

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32218 message to notify end-user N-days prior the password get expired

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-23729 INFORMATION_SCHEMA Table info. about user locked due to max_password_errors

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32649 Add INFORMATION_SCHEMA Table with user related details

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            ralf.gebhardt Ralf Gebhardt added a comment -

            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.

            ralf.gebhardt Ralf Gebhardt added a comment - 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.
            YK Yakov Kushnirsky added a comment -

            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

            YK Yakov Kushnirsky added a comment - 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
            serg Sergei Golubchik added a comment -

            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
            serg Sergei Golubchik added a comment - 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

            People

              Unassigned Unassigned
              YK Yakov Kushnirsky
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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