diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-08-22 18:32:11 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-08-22 18:32:11 +0300 |
| commit | bd6347df9318f46f715615e2a33ff9ba2d9dbb59 (patch) | |
| tree | 002f48e76ec181220ff68780613e4e4667e7e574 /mysql-test/t | |
| parent | 7036fbd3c209c4d246a0370842d2b874060b4631 (diff) | |
| download | mariadb-git-bd6347df9318f46f715615e2a33ff9ba2d9dbb59.tar.gz | |
grant.result, grant.test, sql_acl.cc:
Fix for a bug #878
sql/sql_acl.cc:
Fix for a bug #878
mysql-test/t/grant.test:
Fix for a bug #878
mysql-test/r/grant.result:
Fix for a bug #878
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/grant.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index 5b20354336c..f278a720cd6 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -66,6 +66,16 @@ REVOKE insert,insert (a) on t1 from mysqltest_1@localhost; GRANT references on t1 to mysqltest_1@localhost; show grants for mysqltest_1@localhost; select table_priv,column_priv from mysql.tables_priv where user="mysqltest_1"; +grant all on test.* to user1@localhost with grant option; +revoke all on test.* from user1@localhost; +show grants for user1@localhost; +revoke grant option on test.* from user1@localhost; +show grants for user1@localhost; +grant all on test.t1 to user2@localhost with grant option; +revoke all on test.t1 from user2@localhost; +show grants for user2@localhost; +revoke grant option on test.t1 from user2@localhost; +show grants for user2@localhost; delete from mysql.user where user='mysqltest_1'; delete from mysql.db where user='mysqltest_1'; delete from mysql.tables_priv where user='mysqltest_1'; |