diff options
| author | monty@mashka.mysql.fi <> | 2003-05-08 00:12:46 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-05-08 00:12:46 +0300 |
| commit | 5d5d5b08ac4e69b4654e076379b3b8a68bc3c5ea (patch) | |
| tree | 60b20adcf362b4f6c7b1eca99610284503335375 /tests/grant.pl | |
| parent | 38bb63e16bec82af522d50d1100fb777da7856e2 (diff) | |
| parent | 71ce598fa21e2e8ee3abf156af2cd95821f3d282 (diff) | |
| download | mariadb-git-5d5d5b08ac4e69b4654e076379b3b8a68bc3c5ea.tar.gz | |
Merge to get security patch
Diffstat (limited to 'tests/grant.pl')
| -rw-r--r-- | tests/grant.pl | 13 |
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); |