v.20.10New Feature

Secure Inter-Cluster Query Execution Enhancements

Secure inter-cluster query execution (with initial_user as current query user). #13156 (Azat Khuzhin). #15551 (Azat Khuzhin).
Introduces secure inter-cluster query execution in ClickHouse by running queries with initial_user as the current query user.

Why it matters

This feature enhances security in distributed ClickHouse environments by ensuring that inter-cluster queries are executed with the permissions of the original querying user, preventing privilege escalation and improving access control consistency across clusters.

How to use it

To use this feature, inter-cluster queries should be executed with the configuration or settings that enable running queries as initial_user, which represents the identity of the original query initiator. This ensures that user permissions are respected during remote query execution.