summaryrefslogtreecommitdiff
path: root/mysql-test/r/grant3.result
diff options
context:
space:
mode:
authorunknown <jani@ua141d10.elisa.omakaista.fi>2005-03-22 15:57:24 +0200
committerunknown <jani@ua141d10.elisa.omakaista.fi>2005-03-22 15:57:24 +0200
commit06abeb4f639d8f06901588c4a958cba3eaee3a74 (patch)
treed059977e7bf9355db26e81322219225f4d2e3368 /mysql-test/r/grant3.result
parent523a421725d24ab16b2ba68c16c17b940fc9e226 (diff)
downloadmariadb-git-06abeb4f639d8f06901588c4a958cba3eaee3a74.tar.gz
- Added new error message.
- Changed error message in sql_acl.cc - Added some more tests for GRANT. Docs/mysqld_error.txt: Added new error message. mysql-test/r/grant2.result: Error message changed. mysql-test/r/grant3.result: Clean up. mysql-test/t/grant2.test: Error message changed. sql/share/errmsg.txt: Added new error message. sql/sql_acl.cc: Changed error message. mysql-test/t/grant3.test: Error message changed.
Diffstat (limited to 'mysql-test/r/grant3.result')
-rw-r--r--mysql-test/r/grant3.result17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/grant3.result b/mysql-test/r/grant3.result
new file mode 100644
index 00000000000..ae37db3af42
--- /dev/null
+++ b/mysql-test/r/grant3.result
@@ -0,0 +1,17 @@
+SET NAMES binary;
+drop table if exists t1;
+delete from mysql.user where user like 'mysqltest\_%';
+delete from mysql.db where user like 'mysqltest\_%';
+delete from mysql.tables_priv where user like 'mysqltest\_%';
+delete from mysql.columns_priv where user like 'mysqltest\_%';
+flush privileges;
+create user mysqltest_1@localhost;
+grant grant option on mysql.* to mysqltest_1@localhost;
+grant select on `my\_1`.* to mysqltest_1@localhost with grant option;
+grant select on `my\_1`.* to mysqltest_2@localhost;
+ERROR HY000: You are not allowed to create a user with GRANT
+delete from mysql.user where user like 'mysqltest\_%';
+delete from mysql.db where user like 'mysqltest\_%';
+delete from mysql.tables_priv where user like 'mysqltest\_%';
+delete from mysql.columns_priv where user like 'mysqltest\_%';
+flush privileges;