SHOW GRANTS ON SHARE

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only

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 actionType objectType objectKey
  --------- ---------- ---------- ---------
  some_corp SELECT
  other_org SELECT

Related articles

• GRANT TO SHARE

• REVOKE ON SHARE

• SHOW GRANTS

• SHOW GRANTS TO RECIPIENT

• SHOW SHARES

• SHOW RECIPIENTS