summaryrefslogtreecommitdiff
path: root/sql/sql_insert.cc
diff options
context:
space:
mode:
authorevgen@sunlight.local <>2006-08-15 21:45:24 +0400
committerevgen@sunlight.local <>2006-08-15 21:45:24 +0400
commitdd9a07706b9c463c9ab887232ef4873f49a39cd5 (patch)
treea81bf82a292cd0862ecfaedcf0c1317a9ccdb0a7 /sql/sql_insert.cc
parent5f3d231f5706d43572a1f90873db6ee98226bfcb (diff)
downloadmariadb-git-dd9a07706b9c463c9ab887232ef4873f49a39cd5.tar.gz
Fixed bug#21261: Wrong access rights was required for an insert into a view
SELECT right instead of INSERT right was required for an insert into to a view. This wrong behaviour appeared after the fix for bug #20989. Its intention was to ask only SELECT right for all tables except the very first for a complex INSERT query. But that patch has done it in a wrong way and lead to asking a wrong access right for an insert into a view. The setup_tables_and_check_access() function now accepts two want_access parameters. One will be used for the first table and the second for other tables.
Diffstat (limited to 'sql/sql_insert.cc')
-rw-r--r--sql/sql_insert.cc2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/sql_insert.cc b/sql/sql_insert.cc
index 57805da608b..c08deedea72 100644
--- a/sql/sql_insert.cc
+++ b/sql/sql_insert.cc
@@ -847,7 +847,7 @@ static bool mysql_prepare_insert_check_table(THD *thd, TABLE_LIST *table_list,
&thd->lex->select_lex.top_join_list,
table_list, where,
&thd->lex->select_lex.leaf_tables,
- select_insert, SELECT_ACL))
+ select_insert, INSERT_ACL, SELECT_ACL))
DBUG_RETURN(TRUE);
if (insert_into_view && !fields.elements)