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

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

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

28.3.29 INFORMATION_SCHEMA ROLE_TABLE_GRANTS 表28.3.29 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table

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

ROLE_TABLE_GRANTS 表具有以下列:The ROLE_TABLE_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.

  • TABLE_CATALOG

    角色适用的目录名称。该值始终为 def。The name of the catalog to which the role applies. This value is always def.

  • TABLE_SCHEMA

    角色适用的模式(数据库)名称。The name of the schema (database) to which the role applies.

  • TABLE_NAMETABLE_NAME

    角色适用的表名。The name of the table to which the role applies.

  • PRIVILEGE_TYPE

    授予的权限。值可以是任何可以在表级别授予的权限;请参阅 第 15.7.1.6 节,“GRANT 语句”。每行列出一个权限,因此每个受赠者拥有的列权限都会对应一行。The privilege granted. The value can be any privilege that can be granted at the table 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.