REVOKE ON SHARE

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.3 and above

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;