| 1 |
--source include/not_embedded.inc |
| 2 |
|
| 3 |
if (!$AUTH_0X0100_SO) { |
| 4 |
skip No auth_0x0100 plugin; |
| 5 |
} |
| 6 |
|
| 7 |
install soname 'auth_0x0100'; |
| 8 |
|
| 9 |
select plugin_name, plugin_type_version from information_schema.plugins where |
| 10 |
plugin_type='authentication' and plugin_library is not null order by plugin_name; |
| 11 |
|
| 12 |
create user tt identified via auth_0x0100; |
| 13 |
create user zzzzzzzzzzzzzzzz; |
| 14 |
grant select on test.* to zzzzzzzzzzzzzzzz; |
| 15 |
|
| 16 |
--replace_result $MASTER_MYSOCK MASTER_MYSOCK $MASTER_MYPORT MASTER_MYPORT |
| 17 |
--error ER_ACCESS_DENIED_ERROR |
| 18 |
connect (c0,localhost,tt); |
| 19 |
|
| 20 |
grant proxy on zzzzzzzzzzzzzzzz to tt; |
| 21 |
connect (c1,localhost,tt); |
| 22 |
connection c1; |
| 23 |
|
| 24 |
--query_vertical select user(), current_user(), @@external_user |
| 25 |
connection default; |
| 26 |
drop user tt; |
| 27 |
drop user zzzzzzzzzzzzzzzz; |
| 28 |
uninstall plugin auth_0x0100; |