From 14ddcb1ff27dbb7248c63a01756852404b6d5209 Mon Sep 17 00:00:00 2001
From: Sergei Golubchik <serg@mariadb.org>
Date: Thu, 2 Aug 2018 22:28:04 +0200
Subject: Bug#27407480: AUTOMATIC_SP_PRIVILEGES REQUIRES NEED THE INSERT
 PRIVILEGES FOR MYSQL.USER TABLE

A test case and a followup fix
---
 sql/sql_acl.cc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/sql_acl.cc')

diff --git a/sql/sql_acl.cc b/sql/sql_acl.cc
index 24740a0695a..066e7e4c7f4 100644
--- a/sql/sql_acl.cc
+++ b/sql/sql_acl.cc
@@ -7190,7 +7190,7 @@ bool sp_grant_privileges(THD *thd, const char *sp_db, const char *sp_name,
   mysql_mutex_lock(&acl_cache->lock);
 
  if ((au= find_acl_user(combo->host.str= (char *) sctx->priv_host,
-                        combo->user.str, FALSE)))
+                        combo->user.str, TRUE)))
     goto found_acl;
 
   mysql_mutex_unlock(&acl_cache->lock);
-- 
cgit v1.2.1