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).
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 asinitial_user, which represents the identity of the original query initiator. This ensures that user permissions are respected during remote query execution.