METASTORE_PRIVILEGES

  • Article

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.METASTORE_PRIVILEGES lists principals that have privileges on the current metastore.

This is an extension to the SQL Standard Information Schema.

Definition

The METASTORE_PRIVILEGES relation contains the following columns:

Name Data type Nullable Description
GRANTOR STRING No Principal that granted the privilege.
GRANTEE STRING No Principal to which the privilege is granted.
METASTORE_ID STRING No Metastore on which the privilege is granted.
PRIVILEGE_TYPE STRING No Privilege being granted.
IS_GRANTABLE STRING No 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 METASTORE_PRIVILEGES relation:

Class Name Column List Description
Primary key METPRIVS_PK GRANTOR, GRANTEE, METASTORE_ID, PRIVILEGE_TYPE Unique identifier for the granted privilege.
Foreign key METPRIVS_METS_FK METASTORE_ID References METASTORES

Examples

> SELECT metastore_id, grantee
    FROM information_schema.metastore_privileges;