mirror of
https://github.com/MariaDB/server.git
synced 2025-08-10 04:21:36 +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.
37 lines
1.1 KiB
Text
37 lines
1.1 KiB
Text
#
|
|
# Start of 10.5 tests
|
|
#
|
|
#
|
|
# MDEV-21743 Split up SUPER privilege to smaller privileges
|
|
#
|
|
#
|
|
# Test that master admin statements are not allowed without REPLICATION MASTER ADMIN
|
|
#
|
|
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;
|
|
SHOW SLAVE HOSTS;
|
|
ERROR 42000: Access denied; you need (at least one of) the REPLICATION MASTER ADMIN privilege(s) for this operation
|
|
disconnect con1;
|
|
connection default;
|
|
DROP USER user1@localhost;
|
|
#
|
|
# Test that master admin statements are allowed with REPLICATION MASTER ADMIN
|
|
#
|
|
CREATE USER user1@localhost IDENTIFIED BY '';
|
|
GRANT REPLICATION MASTER ADMIN ON *.* TO user1@localhost;
|
|
SHOW GRANTS FOR user1@localhost;
|
|
Grants for user1@localhost
|
|
GRANT REPLICATION MASTER ADMIN ON *.* TO `user1`@`localhost`
|
|
connect con1,localhost,user1,,;
|
|
connection con1;
|
|
SHOW SLAVE HOSTS;
|
|
Server_id Host Port Master_id
|
|
connection default;
|
|
disconnect con1;
|
|
DROP USER user1@localhost;
|
|
#
|
|
# End of 10.5 tests
|
|
#
|