STORAGE_CREDENTIAL_PRIVILEGES

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.STORAGE_CREDENTIAL_PRIVILEGES lists principals that have privileges on a storage credential.

This is an extension to the SQL Standard Information Schema.

Warning

Starting with Databricks Runtime 15.4, this relation is deprecated. Use INFORMATION_SCHEMA.CREDENTIAL_PRIVILEGES instead.

Note also that during the service credentials preview, INFORMATION_SCHEMA.STORAGE_CREDENTIAL_PRIVILEGES displays privileges that apply both to storage credentials and service credentials. This is incorrect preview behavior that will be corrected, and you should not depend on it to continue.

Definition

The STORAGE_CREDENTIAL_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.
STORAGE_CREDENTIAL_NAME STRING No Storage credential 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 STORAGE_CREDENTIAL_PRIVILEGES relation:

Class Name Column List Description
Primary key METPRIVS_PK GRANTOR, GRANTEE, STORAGE_CREDENTIAL_NAME, PRIVILEGE_TYPE Unique identifier for the granted privilege.
Foreign key METPRIVS_METS_FK STORAGE_CREDENTIAL_NAME References STORAGE_CREDENTIALS

Examples

> SELECT storage_credential_name, grantee
    FROM information_schema.storage_credential_privileges;