Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: Databricks SQL
Databricks Runtime 10.4 LTS 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.
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 | The ancestor relation that the privilege is inherited from. |
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 |
> SELECT share_name, recipient_name
FROM information_schema.share_recipient_privileges;