summaryrefslogtreecommitdiff
path: root/tests/grant.pl
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2002-09-22 18:02:39 +0300
committerunknown <monty@mashka.mysql.fi>2002-09-22 18:02:39 +0300
commit92dd03932df128eed8164bc3c85e7c9d3306e77b (patch)
tree7f6749bdfc76c04b8808fc36f0afc50291749ae8 /tests/grant.pl
parent6546f36e2d8378f224114b88cae3806684990162 (diff)
downloadmariadb-git-92dd03932df128eed8164bc3c85e7c9d3306e77b.tar.gz
Don't give the anonymous user create temp table or lock tables privileges.
SET PASSWORD=... closed connection on error. Docs/manual.texi: Changelog mysql-test/r/rpl_rotate_logs.result: Fixed test scripts/mysql_fix_privilege_tables.sh: Don't give the anonymous user create temp table or lock tables privileges. sql/set_var.cc: SET PASSWORD=... closed connection on error, because MySQL sent the error message twice. sql/set_var.h: SET PASSWORD=... closed connection on error, because MySQL sent the error message twice. sql/sql_acl.cc: Added function comment sql/sql_db.cc: Change type of variable sql/sql_parse.cc: SET PASSWORD=... closed connection on error, because MySQL sent the error message twice. tests/grant.pl: Updated grant test case to work with latest MySQL version tests/grant.res: updated test results
Diffstat (limited to 'tests/grant.pl')
-rw-r--r--tests/grant.pl3
1 files changed, 2 insertions, 1 deletions
diff --git a/tests/grant.pl b/tests/grant.pl
index 1cd72af48fe..9212c610ac1 100644
--- a/tests/grant.pl
+++ b/tests/grant.pl
@@ -435,8 +435,9 @@ user_connect(0);
user_query("LOCK TABLES $opt_database.test3 READ");
user_query("UNLOCK TABLES");
safe_query("revoke SELECT,INSERT,UPDATE,DELETE on $opt_database.test3 from $user");
-user_connect(1);
+user_connect(0);
safe_query("revoke LOCK TABLES on *.* from $user");
+user_connect(1);
safe_query("drop table $opt_database.test3");
#