TABLE_PRIVILEGES
Applies to: 
Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only
INFORMATION_SCHEMA.TABLE_PRIVILEGES lists principals that have privileges on a table in a catalog schema.
Note
Currently, users with the MANAGE privilege on an object cannot view all grants for that object in the INFORMATION_SCHEMA. Instead, the INFORMATION_SCHEMA only shows grants their own grants on the object. This behavior will be corrected in the future.
Users with MANAGE privilege can view all grants on an object using SQL commands or Catalog Explorer. See Manage privileges in Unity Catalog.
Definition
The TABLE_PRIVILEGES relation contains the following columns:
| Name | Data type | Nullable | Standard | Description |
|---|---|---|---|---|
GRANTOR |
STRING |
No | Yes | Principal that granted the privilege. |
GRANTEE |
STRING |
No | Yes | Principal to which the privilege is granted. |
TABLE_CATALOG |
STRING |
No | Yes | Catalog of relation on which the privilege is granted. |
TABLE_SCHEMA |
STRING |
No | Yes | Schema of relation on which the privilege is granted. |
TABLE_NAME |
STRING |
No | Yes | Relation on which the privilege is granted. |
PRIVILEGE_TYPE |
STRING |
No | Yes | Privilege being granted. |
IS_GRANTABLE |
STRING |
No | Yes | Always NO. Reserved for future use. |
INHERITED_FROM |
STRING |
No | No | The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the TABLE_PRIVILEGES relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | TABLEPRIVS_PK |
GRANTOR, GRANTEE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, PRIVILEGE_TYPE |
Unique identifier for the granted privilege. |
| Foreign key | TABLEPRIVS_TABLES_FK |
TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME |
References TABLES |
Examples
> SELECT table_catalog, table_schema, table_name, grantee
FROM information_schema.table_privileges;