diff options
author | pekka@mysql.com <> | 2005-03-28 23:06:19 +0200 |
---|---|---|
committer | pekka@mysql.com <> | 2005-03-28 23:06:19 +0200 |
commit | 727015dbb378ebf788e4962feeb46e5f64f73b25 (patch) | |
tree | e6080a4ea78a3fdff6cf8095ab0d0d77de2e3120 /mysql-test/t/grant2.test | |
parent | 2a428a1af9e1341f25e1541d79ac3afe77b85e0a (diff) | |
parent | a259bcebd7d34c0e6522222e23d9bc6c471021dd (diff) | |
download | mariadb-git-727015dbb378ebf788e4962feeb46e5f64f73b25.tar.gz |
Merge
Diffstat (limited to 'mysql-test/t/grant2.test')
-rw-r--r-- | mysql-test/t/grant2.test | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/mysql-test/t/grant2.test b/mysql-test/t/grant2.test index 923e65e9e1d..528e3fde173 100644 --- a/mysql-test/t/grant2.test +++ b/mysql-test/t/grant2.test @@ -9,6 +9,7 @@ SET NAMES binary; # prepare playground before tests --disable_warnings drop database if exists mysqltest; +drop database if exists mysqltest_1; --enable_warnings delete from mysql.user where user like 'mysqltest\_%'; delete from mysql.db where user like 'mysqltest\_%'; @@ -56,7 +57,6 @@ grant create user on *.* to mysqltest_1@localhost; connect (user1,localhost,mysqltest_1,,); connection user1; select current_user(); -select current_user; grant all privileges on `my\_1`.* to mysqltest_2@localhost with grant option; --error 1044 grant all privileges on `my_%`.* to mysqltest_3@localhost with grant option; @@ -83,6 +83,24 @@ delete from mysql.user where user like 'mysqltest\_%'; delete from mysql.db where user like 'mysqltest\_%'; flush privileges; +# +# wild_compare part two - acl_cache +# +create database mysqltest_1; +grant all privileges on `mysqltest\_1`.* to mysqltest_1@localhost with grant option; +connect (user2,localhost,mysqltest_1,,); +connection user2; +select current_user(); +show databases; +--error 1044 +grant all privileges on `mysqltest_1`.* to mysqltest_1@localhost with grant option; +disconnect user2; +connection default; +show grants for mysqltest_1@localhost; +delete from mysql.user where user like 'mysqltest\_%'; +delete from mysql.db where user like 'mysqltest\_%'; +drop database mysqltest_1; +flush privileges; # # Bug #6173: One can circumvent missing UPDATE privilege if he has SELECT |