Bug #63785 select from database that I granted permissions immediately before
Submitted: 18 Dec 2011 4:53 Modified: 18 Jan 2012 8:19
Reporter: Peter Davis Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.5 OS:Windows (7)
Assigned to: CPU Architecture:Any

[18 Dec 2011 4:53] Peter Davis 
Description:
the following sql caused an exception:
select * from agency.tapes;

It's quite possible that some important config setting was not updated, since immediately beforehand, I had imported the agency database and then, as root, granted select permission to user=pdc.

How to repeat:
open two workbench connections, one as root, one as user pdc

I import a database called agency from a dump directory.  make sure that there is a table called tapes.

as root:
grant select on  `agency`.`tapes` to 'pdc';

then, as user pdc:

select * from agency.tapes;

Suggested fix:
I'm not sure
[18 Dec 2011 8:19] Valeriy Kravchuk 
What if you close connection as used 'pdc' and open it again, as same user? Will you be able to access this table?
[19 Jan 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".