REVOKE 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.

Revokes access to a share from a recipient.

Syntax 

REVOKE SELECT ON SHARE share_name FROM RECIPIENT recipient_name

Parameters

  • share_name

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

  • recipient_name

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

Examples 

> REVOKE SELECT ON SHARE vaccines FROM RECIPIENT jab_me_now_corp;