MySQL - Finding Grants for Tables
MySQL table grants are stored in the TABLE_PRIVILEGES table in the information_schema database in MySQL. To be able to see the grants defined in the table, the user needs to have permissions to view this table.
The following query will retrieve all grants for the table named employee contained in the database named sample:
SELECT
*
FROM
INFORMATION_SCHEMA.TABLE_PRIVILEGES
WHERE
table_schema = 'sample' AND
table_name = 'employee';
The TABLE_PRIVILEGES view can also be queried to determine table grants for a user. The following query will retrieve all table grants for the user testuser:
SELECT
*
FROM
INFORMATION_SCHEMA.TABLE_PRIVILEGES
WHERE
grantee like '%testuser%';
