Revokes a single privilege on a table from a user or role.
REVOKE <privilege> ON TABLE <zone.schema.table> FROM {USER | ROLE} <grantee>## Overview REVOKE ON TABLE removes a single privilege grant from a user or role. The revoke is idempotent. ## Behavior - Existing sessions are not invalidated. - Schema and zone grants are unaffected. ## Access Control Requires the `ManageGrants` privilege on the table. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
privilege | Specifies the privilege to revoke. | |
table | Specifies the fully qualified table name. | |
grantee_type | Specifies the grantee kind: `USER` or `ROLE`. | |
grantee | Specifies the user or role name. |
REVOKE INSERT ON TABLE silver.staging.orders FROM ROLE pipeline_runner;