summaryrefslogtreecommitdiff
path: root/tests/grant.pl
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-03-14 17:08:42 +0200
committermonty@mashka.mysql.fi <>2003-03-14 17:08:42 +0200
commit5ee1dbbe583e3269eddc6a5c16eb1bd0a8cc6a07 (patch)
tree2c4870b4c69060f127e0c4aca401c4312128a363 /tests/grant.pl
parent6c81552dd3edc97ba2bfea9bccaff9d1ecb2b132 (diff)
downloadmariadb-git-5ee1dbbe583e3269eddc6a5c16eb1bd0a8cc6a07.tar.gz
Check for empty table/column names
Diffstat (limited to 'tests/grant.pl')
-rw-r--r--tests/grant.pl10
1 files changed, 10 insertions, 0 deletions
diff --git a/tests/grant.pl b/tests/grant.pl
index c41b22157bd..bf67ce5e790 100644
--- a/tests/grant.pl
+++ b/tests/grant.pl
@@ -207,6 +207,16 @@ user_query("delete from $opt_database.test where a=1",1);
user_query("update $opt_database.test set b=3 where b=1",1);
user_query("update $opt_database.test set b=b+1",1);
+#
+# Test global SELECT privilege combined with table level privileges
+#
+
+safe_query("grant SELECT on *.* to $user");
+user_connect(0);
+user_query("update $opt_database.test set b=b+1");
+safe_query("revoke SELECT on *.* from $user");
+user_connect(0);
+
# Add one privilege at a time until the user has all privileges
user_query("select * from test",1);
safe_query("grant select on $opt_database.test to $user");