mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 02:51: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.
16 lines
367 B
Text
16 lines
367 B
Text
create role r1;
|
|
create user foo@'127.0.0.1';
|
|
grant r1 to foo@'127.0.0.1';
|
|
connect con1,127.0.0.1,foo,,;
|
|
show grants;
|
|
Grants for foo@127.0.0.1
|
|
GRANT `r1` TO `foo`@`127.0.0.1`
|
|
GRANT USAGE ON *.* TO `foo`@`127.0.0.1`
|
|
set role r1;
|
|
select * from information_schema.enabled_roles;
|
|
ROLE_NAME
|
|
r1
|
|
connection default;
|
|
disconnect con1;
|
|
drop user foo@'127.0.0.1';
|
|
drop role r1;
|