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;

Related

• Information schema

• INFORMATION_SCHEMA.TABLES

• SHOW GRANTS