[MDEV-23280] Establish a grace period for expiry password feature Created: 2020-07-24  Updated: 2020-08-25

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System
Fix Version/s: None

Type: Task Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: authentication

Issue Links:
Relates
relates to MDEV-7597 Expiration of user passwords Closed

 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;


Generated at Thu Feb 08 09:21:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.