summaryrefslogtreecommitdiff
path: root/sql/sql_show.cc
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2019-09-10 17:31:10 +0200
committerSergei Golubchik <serg@mariadb.org>2019-10-28 08:17:56 +0100
commitc075c7a861e4d6062d02ac07fe496f9021601b50 (patch)
treea5c0c153ec03fab9f9d5af47c00873214f1ee47d /sql/sql_show.cc
parentbe780c05559731e09aed2e8a06f93a72d5d51b7f (diff)
downloadmariadb-git-c075c7a861e4d6062d02ac07fe496f9021601b50.tar.gz
MDEV-20549 SQL SECURITY DEFINER does not work for INFORMATION_SCHEMA tables
switch to definer privileges when populating I_S tables
Diffstat (limited to 'sql/sql_show.cc')
-rw-r--r--sql/sql_show.cc1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/sql_show.cc b/sql/sql_show.cc
index 4bc9870f422..8fc0784b77f 100644
--- a/sql/sql_show.cc
+++ b/sql/sql_show.cc
@@ -8429,6 +8429,7 @@ bool get_schema_tables_result(JOIN *join,
cond= tab->cache_select->cond;
}
+ Switch_to_definer_security_ctx backup_ctx(thd, table_list);
if (table_list->schema_table->fill_table(thd, table_list, cond))
{
result= 1;