Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5, 10.6, 10.7, 10.8, 10.9, 10.10
-
None
Description
Upon upgrade from pre-10.5 versions SUPER users are given explicit privileges which SUPER alias includes, apparently for future deprecation of the alias.
However, not all of them are added. SUPER also includes BINLOG_MONITOR and SLAVE_MONITOR privileges, but they are not added to the users with SUPER.
10.5 fb70bb44 |
MariaDB [(none)]> show slave status;
|
Empty set (0.000 sec) |
|
MariaDB [(none)]> show grants;
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| Grants for super@% | |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| GRANT SUPER, SET USER, FEDERATED ADMIN, CONNECTION ADMIN, READ_ONLY ADMIN, REPLICATION SLAVE ADMIN, BINLOG ADMIN, BINLOG REPLAY ON *.* TO `super`@`%` | |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+ |
1 row in set (0.000 sec) |
|
MariaDB [(none)]> show slave status;
|
Empty set (0.000 sec) |