STORAGE_CREDENTIAL_PRIVILEGES
Applies to: Databricks SQL 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;