diff options
| author | unknown <acurtis@pcgem.rdg.cyberkinetica.com> | 2004-11-11 20:59:03 +0000 |
|---|---|---|
| committer | unknown <acurtis@pcgem.rdg.cyberkinetica.com> | 2004-11-11 20:59:03 +0000 |
| commit | b19eb67f08d04de3af744097e72023d550329035 (patch) | |
| tree | c37d7b3a31396a4b126d68d427e3297722413a48 /mysql-test/r/grant.result | |
| parent | 98b31cd63c5fe671d7a3bc7b8e4f2daf20b7ee51 (diff) | |
| download | mariadb-git-b19eb67f08d04de3af744097e72023d550329035.tar.gz | |
Bug#6123 - GRANT USAGE creates useless mysql.db row
Prevent creation of a row which grants no rights
Test included
mysql-test/r/grant.result:
Test for Bug#6123
mysql-test/t/grant.test:
Test for Bug#6123
sql/sql_acl.cc:
Bug#6123
Prevent creation of useless row
Diffstat (limited to 'mysql-test/r/grant.result')
| -rw-r--r-- | mysql-test/r/grant.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result index d4d8dd1f026..f0e5d16e916 100644 --- a/mysql-test/r/grant.result +++ b/mysql-test/r/grant.result @@ -150,3 +150,9 @@ GRANT SELECT ON `ab%`.* TO 'test11'@'localhost' GRANT SELECT ON `a%`.* TO 'test11'@'localhost' delete from mysql.user where user='test11'; delete from mysql.db where user='test11'; +create database db6123; +grant usage on db6123.* to test6123 identified by 'magic123'; +select host,db,user,select_priv,insert_priv from mysql.db where db="db6123"; +host db user select_priv insert_priv +delete from mysql.user where user='test6123'; +drop database db6123; |