From a175314c3e5827eb193872241446f2f8f5c9d33c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:07:14 +0200 Subject: Adding upstream version 1:10.5.12. Signed-off-by: Daniel Baumann --- mysql-test/suite/roles/grant-5771.test | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 mysql-test/suite/roles/grant-5771.test (limited to 'mysql-test/suite/roles/grant-5771.test') diff --git a/mysql-test/suite/roles/grant-5771.test b/mysql-test/suite/roles/grant-5771.test new file mode 100644 index 00000000..3c8f5d2f --- /dev/null +++ b/mysql-test/suite/roles/grant-5771.test @@ -0,0 +1,32 @@ +# +# MDEV-5771 Privileges acquired via roles depend on the order of granting +# +--source include/not_embedded.inc + +create database mysqltest1; +create database mysqltest2; + +create user foo@localhost; +create role r1, r2; +grant all on mysqltest1.* to r1; +grant all on mysqltest2.* to r2; +grant r1 to r2; +grant r2 to foo@localhost; + +--connect (foo,localhost,foo,,) +select current_user; +--error ER_DBACCESS_DENIED_ERROR +show tables in mysqltest1; +--error ER_DBACCESS_DENIED_ERROR +show tables in mysqltest2; +set role r2; +show tables in mysqltest1; +show tables in mysqltest2; +show grants; + +connection default; +drop user foo@localhost; +drop role r1; +drop role r2; +drop database mysqltest1; +drop database mysqltest2; -- cgit v1.2.3