SCHEMA_PRIVILEGES

  • Article

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;