v.21.9New Feature

Add REPLACE GRANT Feature

Official CH changelog text
Add REPLACE GRANT feature. #26384 (Caspian).
Added the REPLACE GRANT feature to ClickHouse, allowing users to replace existing grants with new ones in a single command.

Why it matters

This feature addresses the need to update grants atomically by replacing existing permissions without manually revoking and re-granting them, simplifying permission management and reducing the risk of errors.

How to use it

Use the REPLACE GRANT SQL statement to replace current privileges on a target object with the specified set of privileges in one command, streamlining access control operations.

Related resources

PreviousNext