CATALOG_PRIVILEGES

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only

INFORMATION_SCHEMA.CATALOG_PRIVILEGES lists principals that have privileges on a catalog.

Definition

The CATALOG_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.
`CATALOG_NAME`	`STRING`	No	Yes	Catalog 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`	Yes	No	The ancestor relation that the privilege is inherited from.

The following constraints apply to the CATALOG_PRIVILEGES relation:

Class	Name	Column List	Description
Primary key	`CATPRIVS_PK`	`GRANTOR`, `GRANTEE`, `CATALOG_NAME`, `PRIVILEGE_TYPE`	Unique identifier for the granted privilege.
Foreign key	`CATPRIVS_CATS_FK`	`CATALOG_NAME`	References CATALOGS

SQL
> SELECT catalog_name, grantee
    FROM information_schema.catalog_privileges;