CREDENTIAL_PRIVILEGES
Applies to: 
Databricks Runtime 15.4 and above
INFORMATION_SCHEMA.CREDENTIAL_PRIVILEGES lists principals that have privileges on a credential.
This is an extension to the SQL Standard Information Schema.
Definition
The 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. | |
CREDENTIAL_NAME |
STRING |
No | 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 | No | The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the CREDENTIAL_PRIVILEGES relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | METPRIVS_PK |
GRANTOR, GRANTEE, CREDENTIAL_NAME, PRIVILEGE_TYPE |
Unique identifier for the granted privilege. |
| Foreign key | METPRIVS_METS_FK |
CREDENTIAL_NAME |
References CREDENTIALS |
Examples
> SELECT credential_name, grantee
FROM information_schema.credential_privileges;