Revokes a single privilege on a schema from a user or role.
REVOKE <privilege> ON SCHEMA <zone.schema> FROM {USER | ROLE} <grantee>## Overview REVOKE ON SCHEMA removes a single privilege grant from a user or role. The revoke is idempotent: revoking a grant that was never given succeeds with no error. ## Behavior - The revoke does not cascade to tables. Table-level grants remain intact unless revoked separately. - Existing sessions are not invalidated. ## Access Control Requires the `ManageGrants` privilege on the schema. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
privilege | Specifies the privilege to revoke. | |
schema | Specifies the fully qualified schema. | |
grantee_type | Specifies the grantee kind: `USER` or `ROLE`. | |
grantee | Specifies the user or role name. |
REVOKE CREATE ON SCHEMA silver.staging FROM ROLE pipeline_runner;