EXTERNAL_LOCATION_PRIVILEGES
Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above
INFORMATION_SCHEMA.EXTERNAL_LOCATION_PRIVILEGES lists principals that have privileges on an external location.
This is an extension to the SQL Standard Information Schema.
Definition
The EXTERNAL_LOCATION_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. |
EXTERNAL_LOCATION_NAME |
STRING |
No | External location 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 EXTERNAL_LOCATION_PRIVILEGES
relation:
Class | Name | Column List | Description |
---|---|---|---|
Primary key | LOCPRIVS_PK |
GRANTOR , GRANTEE , EXTERNAL_LOCATION_NAME , PRIVILEGE_TYPE |
Unique identifier for the granted privilege. |
Foreign key | LOCPRIVS_LOCS_FK |
EXTERNAL_LOCATION_NAME |
References EXTERNAL_LOCATIONS |
Examples
> SELECT external_location_name, grantee
FROM information_schema.external_location_privileges;