VOLUME_PRIVILEGES
Applies to: 
Databricks SQL Databricks Runtime 13.3 LTS and above 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;