mirror of
https://github.com/MariaDB/server.git
synced 2025-07-28 06:04:59 +02:00

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.
67 lines
1.8 KiB
Text
67 lines
1.8 KiB
Text
drop database if exists db;
|
|
Warnings:
|
|
Note 1008 Can't drop database 'db'; database doesn't exist
|
|
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;
|
|
Database
|
|
information_schema
|
|
show create database db;
|
|
ERROR 42000: Access denied for user 'beep'@'localhost' to database 'db'
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
table_schema table_name
|
|
set role r1;
|
|
show databases;
|
|
Database
|
|
db
|
|
information_schema
|
|
show create database db;
|
|
Database Create Database
|
|
db CREATE DATABASE `db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
table_schema table_name
|
|
db t1
|
|
db t2
|
|
connection default;
|
|
create role r2;
|
|
create user beep2@'%';
|
|
grant update on db.* to r2;
|
|
grant r2 to beep2;
|
|
connect con2,localhost,beep2,,;
|
|
show databases;
|
|
Database
|
|
information_schema
|
|
show create database db;
|
|
ERROR 42000: Access denied for user 'beep2'@'localhost' to database 'db'
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
table_schema table_name
|
|
set role r2;
|
|
show databases;
|
|
Database
|
|
db
|
|
information_schema
|
|
show create database db;
|
|
Database Create Database
|
|
db CREATE DATABASE `db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */
|
|
select table_schema, table_name from information_schema.tables
|
|
where table_schema = 'db' order by table_name;
|
|
table_schema table_name
|
|
db t1
|
|
db t2
|
|
connection default;
|
|
disconnect con1;
|
|
disconnect con2;
|
|
drop database db;
|
|
drop role r1;
|
|
drop user beep;
|
|
drop role r2;
|
|
drop user beep2;
|