[MDEV-9940] CREATE ROLE blocked by password validation plugin Created: 2016-04-18  Updated: 2016-05-05  Resolved: 2016-05-05

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.1
Fix Version/s: 10.1.14

Type: Bug Priority: Major
Reporter: Kolbe Kegel (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-9908 cracklib plugin crashes server on CRE... Closed
Sprint: 10.1.14

 Description   

Apparently, CREATE ROLE is blocked when using a password validation plugin. It's not clear why this should be the case, or how to avoid this, as there is no way to provide a password when creating a role.

> install soname 'simple_password_check';
 
Query OK, 0 rows affected (0.00 sec)
 
> create role 'myrole';
 
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements


Generated at Thu Feb 08 07:38:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.