Status: Closed (View Workflow)
Affects Version/s: 10.3.13
Fix Version/s: N/A
Environment:FreeBSD 11.2-RELEASE-p7 amd64 GENERIC
Name : mariadb103-server
Version : 10.3.13
Installed on : Sun Mar 3 21:48:39 2019 CET
Origin : databases/mariadb103-server
Architecture : FreeBSD:11:amd64
We have some shell script to create new databases and users for new projects. This script has dedicated user account "sys_dbcreator" with slightly lower privileges than root user. It worked fine for all versions from MySQL 4.1 but stopped with MariaDB 10.3.
We create new database in this shell script and then call GRANT ALL ON `newdb`. TO 'newuser'@'localhost';*
User 'test000' will have ALL privileges which user 'sys_dbcreator' has on database `test000`.
But we got an error:
Privileges which are granted to user sys_dbcreator:
If we use these listed privileges for user 'test000' on database `test000` then it works.
GRANT ALL ON `newdb`. TO 'newuser'@'localhost';* worked on all previous versions of MySQL from 4.1 to 5.5, then we migrated to MariaDB and it also worked for all tested versions to 10.2. MariaDB 10.3 does not work so I think this is a regression on how GRANT ALL works.