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 alwaysdef.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_GRANTABLEYES或NO,取决于该角色是否可以授予其他账户。YESorNO, depending on whether the role is grantable to other accounts.