SHOW GRANTS ON SHARE (Databricks SQL)

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 recipients with access to a share.

To run this command you must be an administrator.

Syntax

SHOW GRANTS ON SHARE

You can also use GRANT as an alternative for GRANTS.

Parameters

  • share_name

    The name of the share whose shares will be listed.

Example

> SHOW GRANTS ON SHARE shared_date;
  recipient privilege
  --------- ---------
  some_corp SELECT
  other_org SELECT