typo fixed, followup for 3fe55fa8be9

1 files changed, 10 insertions, 0 deletions

diff --git a/mysql-test/main/grant3.test b/mysql-test/main/grant3.test
index 67c185bcccd..5337d59efd8 100644
--- a/mysql-test/main/grant3.test
+++ b/mysql-test/main/grant3.test
@@ -224,6 +224,16 @@ create table t1 as values (1),(2),(3);
 create table t1 (a int);
 disconnect foo;
 connection default;
+
+revoke create on db1.* from foo@localhost;
+grant insert on db1.* to foo@localhost;
+connect foo,localhost,foo;
+use db1;
+--error ER_TABLEACCESS_DENIED_ERROR
+create table t2 as values (1),(2),(3);
+disconnect foo;
+
+connection default;
 drop user foo@localhost;
 drop database db1;