summaryrefslogtreecommitdiff
path: root/tests/grant.res
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-03-14 17:08:42 +0200
committerunknown <monty@mashka.mysql.fi>2003-03-14 17:08:42 +0200
commit03b0df9481c6f83ab67c1c79d8c6cc2db0ca9223 (patch)
tree2c4870b4c69060f127e0c4aca401c4312128a363 /tests/grant.res
parentf3eb7fe0c3259b001f77c30844f42f96562c23f1 (diff)
downloadmariadb-git-03b0df9481c6f83ab67c1c79d8c6cc2db0ca9223.tar.gz
Check for empty table/column names
mysql-test/t/create.test: Test for empty table/column name tests/grant.pl: More tests tests/grant.res: More tests
Diffstat (limited to 'tests/grant.res')
-rw-r--r--tests/grant.res5
1 files changed, 5 insertions, 0 deletions
diff --git a/tests/grant.res b/tests/grant.res
index 1c74e5b1d1b..44e20db555f 100644
--- a/tests/grant.res
+++ b/tests/grant.res
@@ -192,6 +192,11 @@ update grant_test.test set b=3 where b=1
Error in execute: select command denied to user: 'grant_user@localhost' for column 'b' 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'
+grant SELECT on *.* to grant_user@localhost
+Connecting grant_user
+update grant_test.test set b=b+1
+revoke SELECT on *.* from grant_user@localhost
+Connecting grant_user
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