The INFORMATION_SCHEMA APPLICABLE_ROLES Table The host name part of the account to which the role is granted. The user name part of the granted role. The host name part of the granted role. YES  or  NO , depending on whether the role is grantable to other accounts. YES  or  NO , depending on whether the role is a default role. YES  or  NO , depending on whether the role is mandatory. The  APPLICABLE_ROLES  table (available as of MySQL 8.0.19) provides information about the roles that are applicable for the current user. The  APPLICABLE_ROLES  table has these columns: The user name part of the current user account. The host name part of the current user account. The user name part of the account to which the role is granted. The host name part of the account to which the role is granted. The user name part of the granted role. The host name part of the granted role. YES  or  NO , depending on whether the role is grantable to other accounts. YES  or  NO , depending on whether the role is a default role. 4779 • ROLE_NAME • ROLE_HOST • IS_GRANTABLE • IS_DEFAULT • IS_MANDATORY 26.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table • USER • HOST • GRANTEE • GRANTEE_HOST • ROLE_NAME • ROLE_HOST • IS_GRANTABLE • IS_DEFAULT