mirror of
https://github.com/MariaDB/server.git
synced 2025-10-24 08:30:51 +02:00
5ee05cb8d7
Follow-up patch with adjustments of test files and updates of result files for tests. Part 5
22 lines
510 B
Text
22 lines
510 B
Text
#
|
|
# MDEV-5232 SET ROLE checks privileges differently from check_access()
|
|
#
|
|
--source include/not_embedded.inc
|
|
create user ''@localhost;
|
|
create user c;
|
|
grant select on mysql.* to c;
|
|
create role r1;
|
|
grant r1 to c;
|
|
connect (c,localhost,c,,,,,);
|
|
select user(), current_user();
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
select user from mysql.user group by user;
|
|
--error ER_INVALID_ROLE
|
|
set role r1;
|
|
disconnect c;
|
|
connection default;
|
|
drop role r1;
|
|
--disable_warnings
|
|
drop user c;
|
|
drop user ''@localhost;
|
|
--enable_warnings
|