mirror of
https://github.com/MariaDB/server.git
synced 2025-07-27 21:55:03 +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.
23 lines
1.3 KiB
Text
23 lines
1.3 KiB
Text
install soname 'auth_0x0100';
|
|
select plugin_name, plugin_type_version from information_schema.plugins where
|
|
plugin_type='authentication' and plugin_library is not null order by plugin_name;
|
|
plugin_name plugin_type_version
|
|
auth_0x0100 1.0
|
|
create user tt identified via auth_0x0100;
|
|
create user zzzzzzzzzzzzzzzz;
|
|
grant select on test.* to zzzzzzzzzzzzzzzz;
|
|
connect(localhost,tt,,test,MASTER_MYPORT,MASTER_MYSOCK);
|
|
connect c0,localhost,tt;
|
|
ERROR 28000: Access denied for user 'tt'@'localhost' (using password: YES)
|
|
grant proxy on zzzzzzzzzzzzzzzz to tt;
|
|
connect c1,localhost,tt;
|
|
connection c1;
|
|
select user(), current_user(), @@external_user;
|
|
user() tt@localhost
|
|
current_user() zzzzzzzzzzzzzzzz@%
|
|
@@external_user oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo.
|
|
connection default;
|
|
disconnect c1;
|
|
drop user tt;
|
|
drop user zzzzzzzzzzzzzzzz;
|
|
uninstall plugin auth_0x0100;
|