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

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

                Dates

                Created:
                Updated:

                  Git Integration