EXTERNAL_LOCATION_PRIVILEGES

Applies to: check marked yes Databricks SQL check marked yes 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;