summaryrefslogtreecommitdiff
path: root/sql/sql_acl.cc
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2022-10-22 17:11:04 +0200
committerSergei Golubchik <serg@mariadb.org>2022-10-22 18:27:06 +0200
commit68fb05c360897112fe14038beffff7937d4337e6 (patch)
treeda3098112601470953f976f4ec637433f21196e1 /sql/sql_acl.cc
parent7a2f99564932ff51e7008da1f6e1553467e469a1 (diff)
downloadmariadb-git-68fb05c360897112fe14038beffff7937d4337e6.tar.gz
MDEV-29851 Cached role privileges are not invalidated when needed
GRANT ROLE can update db-level privileges -> must invalidate acl_cache
Diffstat (limited to 'sql/sql_acl.cc')
-rw-r--r--sql/sql_acl.cc3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/sql_acl.cc b/sql/sql_acl.cc
index 5a2865e535e..059a6ed4127 100644
--- a/sql/sql_acl.cc
+++ b/sql/sql_acl.cc
@@ -7152,7 +7152,10 @@ bool mysql_grant_role(THD *thd, List <LEX_USER> &list, bool revoke)
a role
*/
if (role_as_user)
+ {
propagate_role_grants(role_as_user, PRIVS_TO_MERGE::ALL);
+ acl_cache->clear(1);
+ }
}
mysql_mutex_unlock(&acl_cache->lock);