USER_PRIVILEGES

The USER_PRIVILEGES view contains details about global privileges.

Column	Description
GRANTEE	The account name to which the privilege is granted, in 'user_name'@'host_name' format.
TABLE_CATALOG	The name of the catalog. This value is always def.
PRIVILEGE_TYPE	The specific privilege granted.
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

USER_PRIVILEGES is a nonstandard INFORMATION_SCHEMA view.

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