SHARE_RECIPIENT_PRIVILEGES

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.

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.

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.

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

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

SQL
> SELECT share_name, recipient_name
    FROM information_schema.share_recipient_privileges;