mirror of
https://github.com/MariaDB/server.git
synced 2025-08-04 01:21:54 +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.
79 lines
1.8 KiB
Text
79 lines
1.8 KiB
Text
--source include/not_embedded.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-9614 Roles and Users Longer than 6 characters
|
|
--echo #
|
|
--echo # This test case checks the edge case presented in the MDEV. The
|
|
--echo # real issue is actually apparent when the username is longer than the
|
|
--echo # rolename.
|
|
|
|
--echo #
|
|
--echo # We need a separate database not including test or test_% names. Due to
|
|
--echo # default privileges given on these databases.
|
|
--echo #
|
|
DROP DATABASE IF EXISTS `bug_db`;
|
|
|
|
--echo #
|
|
--echo # The first user did not show the bug as john's length is smaller
|
|
--echo # than client. The bug is apparent most of the time for usertestjohn.
|
|
--echo #
|
|
CREATE USER `john`@`%`;
|
|
CREATE USER `usertestjohn`@`%`;
|
|
CREATE ROLE `client`;
|
|
|
|
--echo #
|
|
--echo # Setup the required tables.
|
|
--echo #
|
|
CREATE DATABASE `bug_db`;
|
|
CREATE TABLE `bug_db`.`t0`(`c0` INT);
|
|
|
|
--echo #
|
|
--echo # Setup select privileges only on the role. Setting the role should give
|
|
--echo # select access to bug_db.t0.
|
|
--echo #
|
|
GRANT SELECT ON `bug_db`.`t0` TO `client`;
|
|
GRANT `client` TO `john`@`%`;
|
|
GRANT `client` TO `usertestjohn`@`%`;
|
|
|
|
--echo #
|
|
--echo # Check to see grants are set.
|
|
--echo #
|
|
SHOW GRANTS FOR `john`@`%`;
|
|
SHOW GRANTS FOR `usertestjohn`@`%`;
|
|
SHOW GRANTS FOR `client`;
|
|
|
|
show databases;
|
|
|
|
--echo #
|
|
--echo # Try using the database as john.
|
|
--echo #
|
|
connect (john, localhost, john,,information_schema);
|
|
|
|
show databases;
|
|
set role client;
|
|
show databases;
|
|
use bug_db;
|
|
|
|
--echo #
|
|
--echo # Try using the database as usertestjohn.
|
|
--echo #
|
|
connect (usertestjohn, localhost, usertestjohn,,information_schema);
|
|
|
|
show databases;
|
|
set role client;
|
|
show databases;
|
|
|
|
show grants;
|
|
use bug_db;
|
|
|
|
|
|
--echo #
|
|
--echo # Cleanup
|
|
--echo #
|
|
connection default;
|
|
disconnect john;
|
|
disconnect usertestjohn;
|
|
drop user john;
|
|
drop user usertestjohn;
|
|
drop role client;
|
|
drop database bug_db;
|