summaryrefslogtreecommitdiff
path: root/tests/grant.pl
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-05-08 00:12:46 +0300
committerunknown <monty@mashka.mysql.fi>2003-05-08 00:12:46 +0300
commit97eef79b023c6210e3aea69a750383b2db748c68 (patch)
tree60b20adcf362b4f6c7b1eca99610284503335375 /tests/grant.pl
parent4d91444b15a9d156875b4ba7df2efc301e10845b (diff)
parenta57e7732897ee7973d82dccea0425c436845066a (diff)
downloadmariadb-git-97eef79b023c6210e3aea69a750383b2db748c68.tar.gz
Merge to get security patch
BitKeeper/etc/logging_ok: auto-union sql/sql_acl.cc: Auto merged tests/grant.pl: Auto merged tests/grant.res: Auto merged BitKeeper/triggers/post-commit: use local file client/mysqldump.c: Merge to get crash fix
Diffstat (limited to 'tests/grant.pl')
-rw-r--r--tests/grant.pl13
1 files changed, 13 insertions, 0 deletions
diff --git a/tests/grant.pl b/tests/grant.pl
index e32431ad63a..fb73be786b6 100644
--- a/tests/grant.pl
+++ b/tests/grant.pl
@@ -223,8 +223,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);