SCHEMA_PRIVILEGES

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

INFORMATION_SCHEMA.SCHEMA_PRIVILEGES lists principals that have privileges on a schema in a catalog.

The rows returned are limited to the schemas the user is privileged to interact with.

Definition

The SCHEMA_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 of schema on which the privilege is granted.
`SCHEMA_NAME`	`STRING`	No	Yes	Schema 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 SCHEMA_PRIVILEGES relation:

Class	Name	Column List	Description
Primary key	`SCHEMAPRIVS_PK`	`GRANTOR`, `GRANTEE`, `CATALOG_NAME`, `SCHEMA_NAME`, `PRIVILEGE_TYPE`	Unique identifier for the granted privilege.
Foreign key	`SCHEMAPRIVS_SCHEMATA_FK`	`CATALOG_NAME`, `SCHEMA_NAME`	References SCHEMATA

SQL
> SELECT catalog_name, schema_name, grantee
    FROM information_schema.schema_privileges;