diff options
| author | monty@mashka.mysql.fi <> | 2002-09-16 15:55:19 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2002-09-16 15:55:19 +0300 |
| commit | c85c33a5c1f56263053f5f372d4526cf9962cf94 (patch) | |
| tree | af207b8432596b36633c5f65e7f268ea2b076d6f /mysql-test/t/grant.test | |
| parent | 3a03bb1d23a093747255b92928232f6a4e9c54b9 (diff) | |
| download | mariadb-git-c85c33a5c1f56263053f5f372d4526cf9962cf94.tar.gz | |
Added CREATE TEMPORARY TABLES and LOCK TABLES to db and host tables
Fixed bug in SELECT ... ORDER BY ... LIMIT
Fixed bug in ALTER TABLE and RENAME TABLE with --lower-case-table-names
Fixed hang when using --with-openssl
Diffstat (limited to 'mysql-test/t/grant.test')
| -rw-r--r-- | mysql-test/t/grant.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index c75069f8c55..7ee3b08cc3b 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -20,3 +20,22 @@ revoke all privileges on mysqltest.* from mysqltest_1@localhost; show grants for mysqltest_1@localhost; delete from mysql.user where user='mysqltest_1'; flush privileges; + +# +# Test that the new db privileges are stored/retrieved correctly +# + +grant CREATE TEMPORARY TABLES, LOCK TABLES on mysqltest.* to mysqltest_1@localhost; +show grants for mysqltest_1@localhost; +flush privileges; +show grants for mysqltest_1@localhost; +revoke CREATE TEMPORARY TABLES on mysqltest.* from mysqltest_1@localhost; +show grants for mysqltest_1@localhost; +grant ALL PRIVILEGES on mysqltest.* to mysqltest_1@localhost with GRANT OPTION; +flush privileges; +show grants for mysqltest_1@localhost; +revoke LOCK TABLES, ALTER on mysqltest.* from mysqltest_1@localhost; +show grants for mysqltest_1@localhost; +revoke all privileges on mysqltest.* from mysqltest_1@localhost; +delete from mysql.user where user='mysqltest_1'; +flush privileges; |