From 153cd6a27f1b798fea6dee3aecf3a95df561c6fa Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Thu, 23 Jul 2020 18:57:40 +0200 Subject: MDEV-23237 mariadb.sys has too many privileges don't GRANT UPDATE ON mysql.global_priv TO mariadb.sys@localhost; --- mysql-test/main/grant.result | 2 -- 1 file changed, 2 deletions(-) (limited to 'mysql-test/main/grant.result') diff --git a/mysql-test/main/grant.result b/mysql-test/main/grant.result index d24f53142d8..456bc251e78 100644 --- a/mysql-test/main/grant.result +++ b/mysql-test/main/grant.result @@ -968,7 +968,6 @@ select * from information_schema.table_privileges; GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PRIVILEGE_TYPE IS_GRANTABLE 'mysqltest_8'@'%' def test t1 UPDATE NO 'mariadb.sys'@'localhost' def mysql global_priv SELECT NO -'mariadb.sys'@'localhost' def mysql global_priv UPDATE NO 'mariadb.sys'@'localhost' def mysql global_priv DELETE NO connect conn5,localhost,mysqltest_8,,; select * from t1; @@ -985,7 +984,6 @@ GRANT USAGE ON *.* TO `mysqltest_8`@`%` select * from information_schema.table_privileges; GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PRIVILEGE_TYPE IS_GRANTABLE 'mariadb.sys'@'localhost' def mysql global_priv SELECT NO -'mariadb.sys'@'localhost' def mysql global_priv UPDATE NO 'mariadb.sys'@'localhost' def mysql global_priv DELETE NO flush privileges; show grants for mysqltest_8@''; -- cgit v1.2.1