From 71ce598fa21e2e8ee3abf156af2cd95821f3d282 Mon Sep 17 00:00:00 2001
From: "monty@mashka.mysql.fi" <>
Date: Wed, 7 May 2003 23:59:24 +0300
Subject: Security patch to remove wrong error when one had a global
 update/delete privilige and a database specific SELECT privilege.

---
 tests/grant.pl | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'tests/grant.pl')

diff --git a/tests/grant.pl b/tests/grant.pl
index bf67ce5e790..8ec83c85349 100644
--- a/tests/grant.pl
+++ b/tests/grant.pl
@@ -214,8 +214,21 @@ user_query("update $opt_database.test set b=b+1",1);
 safe_query("grant SELECT on *.* to $user");
 user_connect(0);
 user_query("update $opt_database.test set b=b+1");
+user_query("update $opt_database.test set b=b+1 where a > 0");
 safe_query("revoke SELECT on *.* from $user");
+safe_query("grant SELECT on $opt_database.* to $user");
 user_connect(0);
+user_query("update $opt_database.test set b=b+1");
+user_query("update $opt_database.test set b=b+1 where a > 0");
+safe_query("grant UPDATE on *.* to $user");
+user_connect(0);
+user_query("update $opt_database.test set b=b+1");
+user_query("update $opt_database.test set b=b+1 where a > 0");
+safe_query("revoke UPDATE on *.* from $user");
+safe_query("revoke SELECT on $opt_database.* from $user");
+user_connect(0);
+user_query("update $opt_database.test set b=b+1 where a > 0",1);
+user_query("update $opt_database.test set b=b+1",1);
 
 # Add one privilege at a time until the user has all privileges
 user_query("select * from test",1);
-- 
cgit v1.2.1