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

Establish a grace period for expiry password feature

    XMLWordPrintable

Details

    Description

      If a user suddenly will be locked (even in sandbox mode) ,
      it can have an impact on some systems,
      epecially if also running some daily scripts with the same user.

      So a grace period can be added.

      during grace period a warning should be thrown with every execution of a query and during login.

      WARNING xxxx (xxxxx): Password expire in x days. Please set a new password.

      Add new variable:
      default_password_grace_period

      Add new keyword for creatiing user:

      optional keyword CREATE USER

      CREATE USER 'user'@'%' identified by 'Secretpass2!' PASSWORD EXPIRE INTERVAL 10 DAY GRACE_PERIOD 1 DAY;

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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