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.res | |
| parent | 38bb63e16bec82af522d50d1100fb777da7856e2 (diff) | |
| parent | 71ce598fa21e2e8ee3abf156af2cd95821f3d282 (diff) | |
| download | mariadb-git-5d5d5b08ac4e69b4654e076379b3b8a68bc3c5ea.tar.gz | |
Merge to get security patch
Diffstat (limited to 'tests/grant.res')
| -rw-r--r-- | tests/grant.res | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/tests/grant.res b/tests/grant.res index a50f73740c6..7947ca692b6 100644 --- a/tests/grant.res +++ b/tests/grant.res @@ -200,8 +200,23 @@ Error in execute: SELECT command denied to user: 'grant_user@localhost' for colu grant SELECT on *.* to grant_user@localhost Connecting grant_user update grant_test.test set b=b+1 +update grant_test.test set b=b+1 where a > 0 revoke SELECT on *.* from grant_user@localhost +grant SELECT on grant_test.* to grant_user@localhost Connecting grant_user +update grant_test.test set b=b+1 +update grant_test.test set b=b+1 where a > 0 +grant UPDATE on *.* to grant_user@localhost +Connecting grant_user +update grant_test.test set b=b+1 +update grant_test.test set b=b+1 where a > 0 +revoke UPDATE on *.* from grant_user@localhost +revoke SELECT on grant_test.* from grant_user@localhost +Connecting grant_user +update grant_test.test set b=b+1 where a > 0 +Error in execute: select command denied to user: 'grant_user@localhost' for column 'a' in table 'test' +update grant_test.test set b=b+1 +Error in execute: select command denied to user: 'grant_user@localhost' for column 'b' in table 'test' select * from test Error in execute: select command denied to user: 'grant_user@localhost' for table 'test' grant select on grant_test.test to grant_user@localhost |