diff options
| author | acurtis@pcgem.rdg.cyberkinetica.com <> | 2004-11-11 20:59:03 +0000 |
|---|---|---|
| committer | acurtis@pcgem.rdg.cyberkinetica.com <> | 2004-11-11 20:59:03 +0000 |
| commit | 2ad7d5c662d785664ac3690240e89ce8d11ed21f (patch) | |
| tree | c37d7b3a31396a4b126d68d427e3297722413a48 /mysql-test/r/grant.result | |
| parent | 54dac2cfacd931a3afc972d380ae2a27ee38be6b (diff) | |
| download | mariadb-git-2ad7d5c662d785664ac3690240e89ce8d11ed21f.tar.gz | |
Bug#6123 - GRANT USAGE creates useless mysql.db row
Prevent creation of a row which grants no rights
Test included
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; |