MySQL :: MySQL 8.4 参考手册 :: 28.3.3 INFORMATION_SCHEMA APPLICABLE

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 67%

APPLICABLE_ROLES 表提供关于当前用户可用角色的信息。The APPLICABLE_ROLES table provides information about the roles that are applicable for the current user.

APPLICABLE_ROLES 表有以下列：The APPLICABLE_ROLES table has these columns:

USERUSER
当前用户账户的用户名部分。The user name part of the current user account.
HOSTHOST
当前用户账户的主机名部分。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 或 NO，取决于该角色是否可以授予其他账户。YES or NO, depending on whether the role is grantable to other accounts.
IS_DEFAULT
YES 或 NO，取决于该角色是否为默认角色。YES or NO, depending on whether the role is a default role.
IS_MANDATORY
YES 或 NO，取决于该角色是否为强制角色。YES or NO, depending on whether the role is mandatory.