VOLUME_PRIVILEGES

  • Article

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 13.3 LTS and above check marked yes Unity Catalog only

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

This is an extension to the SQL Standard Information Schema.

Definition

The VOLUME_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.
VOLUME_CATALOG STRING No Catalog of relation on which the privilege is granted.
VOLUME_SCHEMA STRING No Schema of relation on which the privilege is granted.
VOLUME_NAME STRING No Volume 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 Yes The ancestor relation that the privilege is inherited from.

Constraints

The following constraints apply to the VOLUME_PRIVILEGES relation:

Class Name Column List Description
Primary key VOLUMEPRIVS_PK GRANTOR, GRANTEE, VOLUME_CATALOG, VOLUME_SCHEMA, VOLUME_NAME, PRIVILEGE_TYPE Unique identifier for the granted privilege.
Foreign key VOLUMEPRIVS_VOLUMES_FK VOLUME_CATALOG, VOLUME_SCHEMA, VOLUME_NAME References VOLUMES

Examples

> SELECT volume_catalog, volume_schema, volume_name, grantee
    FROM information_schema.volume_privileges;