SCHEMA_PRIVILEGES

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above check marked yes 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.

Constraints

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

Examples 

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