The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table • ROUTINE_SCHEMA • ROUTINE_NAME • PRIVILEGE_TYPE • IS_GRANTABLE • GRANTOR • GRANTOR_HOST • GRANTEE • GRANTEE_HOST • TABLE_CATALOG • TABLE_SCHEMA • TABLE_NAME • PRIVILEGE_TYPE • IS_GRANTABLE The privilege granted. The value can be any privilege that can be granted at the table level; see Section 13.7.1.6, “GRANT Statement” . Each row lists a single privilege, so there is one row per column privilege held by the grantee. The name of the table to which the role applies. The name of the schema (database) to which the role applies. The name of the catalog to which the role applies. This value is always  def . The host name part of the account to which the role is granted. The user name part of the account to which the role is granted. The host name part of the account that granted the role. The user name part of the account that granted the role. The  ROLE_TABLE_GRANTS  table has these columns: The  ROLE_TABLE_GRANTS  table (available as of MySQL 8.0.19) provides information about the table privileges for roles that are available to or granted by the currently enabled roles. YES  or  NO , depending on whether the role is grantable to other accounts. The privilege granted. The value can be any privilege that can be granted at the routine level; see Section 13.7.1.6, “GRANT Statement” . Each row lists a single privilege, so there is one row per column privilege held by the grantee. The name of the routine. The name of the schema (database) to which the routine belongs. 26.3.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table 4815