METASTORE_PRIVILEGES

Applies to: Databricks SQL 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	The ancestor relation that the privilege is inherited from.

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	The ancestor relation that the privilege is inherited from.

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

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

SQL
> SELECT metastore_id, grantee
    FROM  system.information_schema.metastore_privileges;