SHOW GRANTS TO RECIPIENT

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 shares which the recipient can access.

To run this command you must be an administrator.

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