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 |
---|---|---|---|
|
|
No |
Principal that granted the privilege. |
|
|
No |
Principal to which the privilege is granted. |
|
|
No |
Catalog of relation on which the privilege is granted. |
|
|
No |
Schema of relation on which the privilege is granted. |
|
|
No |
Volume on which the privilege is granted. |
|
|
No |
Privilege being granted. |
|
|
No |
Always |
|
|
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 |
|
|
Unique identifier for the granted privilege. |
Foreign key |
|
|
References VOLUMES |