SHOW GRANTS TO RECIPIENT

Preview

Delta Sharing is in Public Preview. To participate in the preview, you must enable the External Data Sharing feature group in the Databricks Account Console. See Enable the External Data Sharing feature group for your account.

Delta Sharing is subject to applicable terms. Enabling the External Data Sharing feature group represents acceptance of those terms.

Displays all shares which the recipient can access.

To run this command you must be an administrator.

Since: Databricks Runtime 10.3

Syntax

SHOW GRANTS TO RECIPIENT recipient_name

You can also use GRANT as an alternative for GRANTS.

Parameters

  • recipient_name

    The name of the recipient whose shares will be listed.

Example

> SHOW GRANTS TO RECIPIENT a_corp;
  share privilege
  ----- ---------
  data1 SELECT
  data2 SELECT