From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/roles/set_role-database-recursive.test | 64 ++++++++++++++++++++++ 1 file changed, 64 insertions(+) create mode 100644 mysql-test/suite/roles/set_role-database-recursive.test (limited to 'mysql-test/suite/roles/set_role-database-recursive.test') diff --git a/mysql-test/suite/roles/set_role-database-recursive.test b/mysql-test/suite/roles/set_role-database-recursive.test new file mode 100644 index 00000000..17c93d45 --- /dev/null +++ b/mysql-test/suite/roles/set_role-database-recursive.test @@ -0,0 +1,64 @@ +source include/not_embedded.inc; + +#create a user with no privileges +create user test_user@localhost; +create role test_role1; +create role test_role2; + +grant test_role1 to test_user@localhost; +grant test_role2 to test_user@localhost; +grant test_role2 to test_role1; +--sorted_result +select user, host from mysql.user where user not like 'root'; +--sorted_result +select * from mysql.roles_mapping; + +--sorted_result +select user, host from mysql.db; + +grant select on mysql.* to test_role2; +flush privileges; + +change_user 'test_user'; + +--error ER_TABLEACCESS_DENIED_ERROR +select * from mysql.roles_mapping; + +select current_user(), current_role(); +set role test_role1; +select current_user(), current_role(); +--sorted_result +select * from mysql.roles_mapping; +set role none; +select current_user(), current_role(); +--error ER_TABLEACCESS_DENIED_ERROR +select * from mysql.roles_mapping; +set role test_role2; +select current_user(), current_role(); +--sorted_result +select * from mysql.roles_mapping; + +change_user 'root'; + +create role test_role3; +grant test_role3 to test_role2; +create role test_role4; +grant test_role4 to test_role3; + +change_user 'test_user'; +set role test_role1; +--error ER_TABLEACCESS_DENIED_ERROR +delete from mysql.user where user='no such user'; + +change_user 'root'; +grant delete on mysql.* to test_role4; + +change_user 'test_user'; +set role test_role1; +delete from mysql.user where user='no such user'; +--sorted_result +show grants; + +change_user 'root'; +drop user test_user@localhost; +drop role test_role1, test_role2, test_role3, test_role4; -- cgit v1.2.3