SHOW GRANTS ON SHARE

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above check marked yes 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