List of tables that a user has SELECT privilege for in MySQL
You can see what privileges on which tables a user has:
show grants for 'user'@'host';
For example, to see the privileges of user1 (all machines in the network 10.25), run:
show grants for 'user'@'10.25.%.%';
I have never granted per table permissions to MySQL users before, but to do this, you would check that the TABLE_PRIVILEGES
table in the information_schema
database.
That should point you in the right direction.