GRANT 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

Grants access to a share to a recipient.

Syntax 

GRANT SELECT ON SHARE share_name TO RECIPIENT recipient_name

Parameters

  • share_name

    The name of the share which the recipient is granted access to. If the share does not exist an error is raised.

  • recipient_name

    The name of the recipient to which access to the share is granted. If the recipient does not exist an error is raised.

Examples 

> GRANT SELECT ON SHARE vaccines TO RECIPIENT jab_me_now_corp;