mirror of
https://github.com/MariaDB/server.git
synced 2025-08-01 03:47:19 +03: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.
58 lines
1.2 KiB
Plaintext
58 lines
1.2 KiB
Plaintext
--source include/not_embedded.inc
|
|
--source include/default_charset.inc
|
|
|
|
drop database if exists db;
|
|
|
|
create role r1;
|
|
create user beep@'%';
|
|
|
|
create database db;
|
|
create table db.t1 (i int);
|
|
create table db.t2 (b int);
|
|
grant select on db.* to r1;
|
|
grant r1 to beep@'%';
|
|
|
|
--connect (con1,localhost,beep,,)
|
|
show databases;
|
|
--error ER_DBACCESS_DENIED_ERROR
|
|
show create database db;
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
|
|
set role r1;
|
|
show databases;
|
|
show create database db;
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
|
|
|
|
connection default;
|
|
create role r2;
|
|
create user beep2@'%';
|
|
|
|
grant update on db.* to r2;
|
|
grant r2 to beep2;
|
|
--connect (con2,localhost,beep2,,)
|
|
show databases;
|
|
--error ER_DBACCESS_DENIED_ERROR
|
|
show create database db;
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
|
|
set role r2;
|
|
show databases;
|
|
|
|
show create database db;
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
|
|
|
|
connection default;
|
|
disconnect con1;
|
|
disconnect con2;
|
|
drop database db;
|
|
drop role r1;
|
|
drop user beep;
|
|
drop role r2;
|
|
drop user beep2;
|