TABLE_
此 Information Schema 视图为已授予指定（或当前）数据库中每个角色的每个表权限显示一行。
For more information about roles and privileges, see Overview of Access Control.
列
| Column Name | Data Type | Description |
|---|---|---|
| GRANTOR | VARCHAR | Role who granted the table privilege |
| GRANTEE | VARCHAR | Role to whom the table privilege is granted |
| GRANTED_TO | VARCHAR | Type of object that has been granted the privilege |
| TABLE_CATALOG | VARCHAR | Database containing the table on which the privilege is granted |
| TABLE_SCHEMA | VARCHAR | Schema containing the table on which the privilege is granted |
| TABLE_NAME | VARCHAR | Name of the table on which the privilege is granted |
| PRIVILEGE_TYPE | VARCHAR | Type of the granted privilege |
| IS_GRANTABLE | VARCHAR | Whether the privilege was granted WITH GRANT OPTION |
| WITH_HIERARCHY | VARCHAR | Not applicable for Snowflake. |
| CREATED | TIMESTAMP_LTZ | Creation time of the privilege |
使用说明
- 该视图仅显示会话的当前角色已被授予访问权限的对象。
- The PRIVILEGE_TYPE column contains Snowflake privilege types. For example, the owner of a table has the OWNERSHIP privilege, rather than each of the separate privileges (e.g. SELECT, INSERT, DELETE, UPDATE).