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

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

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

28.3.27 INFORMATION_SCHEMA ROLE_COLUMN_GRANTS 表28.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table

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

ROLE_COLUMN_GRANTS 表包含以下列:The ROLE_COLUMN_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.

  • COLUMN_NAMECOLUMN_NAME

    角色适用的列名。The name of the column 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 column 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.