SHARE_RECIPIENT_PRIVILEGES
Applies to: 
Databricks SQL Databricks Runtime 10.2 and above
INFORMATION_SCHEMA.SHARE_RECIPIENT_PRIVILEGES lists recipients that have privileges on a share.
Information is displayed only for shares or recipients for which the user has permission to interact with either.
This is an extension to the SQL Standard Information Schema.
Definition
The SHARE_RECIPIENT_PRIVILEGES relation contains the following columns:
| Name | Data type | Nullable | Description | |
|---|---|---|---|---|
GRANTOR |
STRING |
No | Principal that granted the privilege. | |
RECIPIENT_NAME |
STRING |
No | Recipient to which the privilege is granted. | |
SHARE_NAME |
STRING |
No | Share on which the privilege is granted. | |
PRIVILEGE_TYPE |
STRING |
No | Privilege being granted. | |
INHERITED_FROM |
STRING |
Yes | No | The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the SHARE_RECIPIENT_PRIVILEGES relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | SHARE_RECIPIENT_PRIVS_PK |
GRANTOR, RECIPIENT_NAME, SHARE_NAME, PRIVILEGE_TYPE |
Unique identifier for the granted privilege. |
| Foreign key | SHARE_RECIPIENT_PRIVS_RECIPIENTS_FK |
RECIPIENT_NAME |
References RECIPIENTS |
| Foreign key | SHARE_RECIPIENT_PRIVS_SHARES_FK |
SHARE_NAME |
References SHARES |
Examples
> SELECT share_name, recipient_name
FROM information_schema.share_recipient_privileges;