From 7c638268948dae63be1a9eb3aa83da040e028aba Mon Sep 17 00:00:00 2001
From: "tnurnberg@sin.intern.azundris.com" <>
Date: Fri, 23 Mar 2007 19:24:03 +0100
Subject: Bug #26817: mysqldump fails to backup database containing view with
 invalid definer

give some leeway on required permissions for SHOW FIELDS on views so
an unknonwn DEFINER will no longer break mysqldump
---
 sql/sql_parse.cc | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'sql/sql_parse.cc')

diff --git a/sql/sql_parse.cc b/sql/sql_parse.cc
index 1b8bfd38fc4..40914339cf1 100644
--- a/sql/sql_parse.cc
+++ b/sql/sql_parse.cc
@@ -5159,7 +5159,10 @@ bool check_single_table_access(THD *thd, ulong privilege,
     goto deny;
 
   /* Show only 1 table for check_grant */
-  if (grant_option && check_grant(thd, privilege, all_tables, 0, 1, 0))
+  if (grant_option &&
+      !(all_tables->belong_to_view &&
+        (thd->lex->sql_command == SQLCOM_SHOW_FIELDS)) &&
+      check_grant(thd, privilege, all_tables, 0, 1, 0))
     goto deny;
 
   thd->security_ctx= backup_ctx;
-- 
cgit v1.2.1