mirror of
https://github.com/MariaDB/server.git
synced 2025-08-03 09:01:34 +02:00
e3d9369774
let's always disconnect a user connection before dropping the said user. MariaDB is traditionally very tolerant to active connections of the dropped user, which isn't the case for most other databases. Let's avoid unintentionally spreading incompatible behavior and disconnect before drop. Except in cases when the test specifically tests such a behavior.
47 lines
1 KiB
Text
47 lines
1 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 master admin statements are not allowed without REPLICATION MASTER ADMIN
|
|
--echo #
|
|
|
|
CREATE USER user1@localhost IDENTIFIED BY '';
|
|
GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
|
|
REVOKE REPLICATION MASTER ADMIN ON *.* FROM user1@localhost;
|
|
|
|
connect (con1,localhost,user1,,);
|
|
connection con1;
|
|
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
|
|
SHOW SLAVE HOSTS;
|
|
disconnect con1;
|
|
|
|
connection default;
|
|
DROP USER user1@localhost;
|
|
|
|
|
|
--echo #
|
|
--echo # Test that master admin statements are allowed with REPLICATION MASTER ADMIN
|
|
--echo #
|
|
|
|
CREATE USER user1@localhost IDENTIFIED BY '';
|
|
GRANT REPLICATION MASTER ADMIN ON *.* TO user1@localhost;
|
|
SHOW GRANTS FOR user1@localhost;
|
|
|
|
connect (con1,localhost,user1,,);
|
|
connection con1;
|
|
SHOW SLAVE HOSTS;
|
|
|
|
connection default;
|
|
disconnect con1;
|
|
DROP USER user1@localhost;
|
|
|
|
--echo #
|
|
--echo # End of 10.5 tests
|
|
--echo #
|