SHARE_RECIPIENT_PRIVILEGES

Applies to: check marked yes Databricks SQL check marked yes 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.

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 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;