MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
The ADMINISTRABLE_ROLE_AUTHORIZATIONS
table (available as of MySQL 8.0.19) provides information about
which roles applicable for the current user or role can be granted
to other users or roles.
The ADMINISTRABLE_ROLE_AUTHORIZATIONS
table has these columns:
USER
The user name part of the current user account.
HOST
The host name part of the current user account.
GRANTEE
The user name part of the account to which the role is granted.
GRANTEE_HOST
The host name part of the account to which the role is granted.
ROLE_NAME
The user name part of the granted role.
ROLE_HOST
The host name part of the granted role.
IS_GRANTABLE
YES or NO, depending on
whether the role is grantable to other accounts.
IS_DEFAULT
YES or NO, depending on
whether the role is a default role.
IS_MANDATORY
YES or NO, depending on
whether the role is mandatory.