mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
d6e3d89c80
SUPER privilege used to allow various actions that were alternatively allowed by one of BINLOG ADMIN, BINLOG MONITOR, BINLOG REPLAY, CONNECTION ADMIN, FEDERATED ADMIN, REPL MASTER ADMIN, REPL SLAVE ADMIN, SET USER, SLAVE MONITOR. Now SUPER no longer does that, one has to grant one of the fine-grained privileges above to be to perform corresponding actions. On upgrade from MariaDB versions 10.11 and below all the privileges above are granted automatically if the user has SUPER. As a side-effect, such an upgrade will allow SUPER-user to run SHOW BINLOG EVENTS, SHOW RELAYLOG EVENTS, SHOW SLAVE HOSTS, even if he wasn't able to do it before the upgrade.
53 lines
1.2 KiB
Text
53 lines
1.2 KiB
Text
-- source include/not_embedded.inc
|
|
|
|
--echo #
|
|
--echo # Start of 10.5 tests
|
|
--echo #
|
|
|
|
--echo #
|
|
--echo # MDEV-21743 Split up SUPER privilege to smaller privileges
|
|
--echo #
|
|
|
|
--echo #
|
|
--echo # Test that slave admin statements are not allowed without REPLICATION SLAVE ADMIN
|
|
--echo #
|
|
|
|
CREATE USER user1@localhost IDENTIFIED BY '';
|
|
GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
|
|
REVOKE REPLICATION SLAVE ADMIN ON *.* FROM user1@localhost;
|
|
|
|
connect (con1,localhost,user1,,);
|
|
connection con1;
|
|
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
|
|
START SLAVE;
|
|
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
|
|
CHANGE MASTER TO MASTER_HOST='127.0.0.1';
|
|
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
|
|
STOP SLAVE;
|
|
disconnect con1;
|
|
|
|
connection default;
|
|
DROP USER user1@localhost;
|
|
|
|
--echo #
|
|
--echo # Test that slave admin statements are allowed with REPLICATION SLAVE ADMIN
|
|
--echo #
|
|
|
|
CREATE USER user1@localhost IDENTIFIED BY '';
|
|
GRANT REPLICATION SLAVE ADMIN ON *.* TO user1@localhost;
|
|
SHOW GRANTS FOR user1@localhost;
|
|
|
|
connect (con1,localhost,user1,,);
|
|
connection con1;
|
|
--error ER_BAD_SLAVE
|
|
START SLAVE;
|
|
CHANGE MASTER TO MASTER_USER='root';
|
|
STOP SLAVE;
|
|
disconnect con1;
|
|
|
|
connection default;
|
|
DROP USER user1@localhost;
|
|
|
|
--echo #
|
|
--echo # End of 10.5 tests
|
|
--echo #
|