文档首页
MySQL 8.4 参考手册
8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.3 INFORMATION_SCHEMA 总表 / 28.3.28 INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 表
中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 56%

28.3.28 INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 表28.3.28 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table

ROLE_ROUTINE_GRANTS 表提供有关当前启用角色可用或授予的角色例程权限的信息。The ROLE_ROUTINE_GRANTS table provides information about the routine privileges for roles that are available to or granted by the currently enabled roles.

ROLE_ROUTINE_GRANTS 表包含以下列:The ROLE_ROUTINE_GRANTS table has these columns:

  • GRANTOR

    授予该角色的账户的用户名部分。The user name part of the account that granted the role.

  • GRANTOR_HOST

    授予该角色的账户的主机名部分。The host name part of the account that granted the role.

  • 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.

  • SPECIFIC_CATALOG

    例程所属目录的名称。此值始终为 def。The name of the catalog to which the routine belongs. This value is always def.

  • SPECIFIC_SCHEMA

    该例程所属的模式(数据库)的名称。The name of the schema (database) to which the routine belongs.

  • SPECIFIC_NAME

    例程的名称。The name of the routine.

  • ROUTINE_CATALOG

    例程所属目录的名称。此值始终为 def。The name of the catalog to which the routine belongs. This value is always def.

  • ROUTINE_SCHEMA

    该例程所属的模式(数据库)的名称。The name of the schema (database) to which the routine belongs.

  • ROUTINE_NAME

    例程的名称。The name of the routine.

  • PRIVILEGE_TYPE

    授予的权限。该值可以是可以在例程级别授予的任何权限;请参见 第 15.7.1.6 节,“GRANT 语句”。每行列出单个权限,因此每行对应受赠者所持有的每个列权限。The privilege granted. The value can be any privilege that can be granted at the routine level; see Section 15.7.1.6, “GRANT Statement”. Each row lists a single privilege, so there is one row per column privilege held by the grantee.

  • IS_GRANTABLE

    YES 或 NO,取决于该角色是否可以授予其他账户。YES or NO, depending on whether the role is grantable to other accounts.