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