|
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)
|
|