Bug #9582 incorrect ACL system refresh after its update by GRANT command
Submitted: 2 Apr 2005 14:24 Modified: 17 Jan 2014 15:03
Reporter: Oleksandr Byelkin Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Security: Privileges Severity:S2 (Serious)
Version:5.0 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[2 Apr 2005 14:24] Oleksandr Byelkin
following mysql-test script return error despite operation allowance.
But repeat of 'use <database>'  command refresh ACL and command becomes allowed (see commented line in the script)

How to repeat:
connect (root,localhost,root,,test);
connection root;
create database mysqltest;

grant create,select on test.* to mysqltest_1@localhost;

connect (user1,localhost,mysqltest_1,,test);
connection user1;

create table t1 (a int);

connection root;
grant create,drop,select on test.* to mysqltest_1@localhost;

connection user1;
# if uncomment following command bug will gone
#use test;
drop table t1;

connection root;
revoke all privileges on test.* from mysqltest_1@localhost;

drop database mysqltest;