[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: |
|
||||||||
| Description |
|
If a user suddenly will be locked (even in sandbox mode) , 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: 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; |