TABLE_PRIVILEGES

The TABLE_PRIVILEGES view contains information about table privileges.

Column	Description
GRANTEE	The account to which the privilege is granted, in 'user_name'@'host_name' format.
TABLE_CATALOG	The catalog to which the table belongs. This value is always def.
TABLE_SCHEMA	The schema (database) to which the table belongs.
TABLE_NAME	The name of the table.
PRIVILEGE_TYPE	The granted privilege.
IS_GRANTABLE	Indicates whether the user has the GRANT OPTION privilege: YES if they do, NO if not. GRANT OPTION isn’t listed as a separate row with PRIVILEGE_TYPE='GRANT OPTION'.

Note

TABLE_PRIVILEGES is a nonstandard INFORMATION_SCHEMA view.

For more information, see the MySQL documentation: The INFORMATION_SCHEMA TABLE_PRIVILEGES Table.