v.20.3Improvement

Support Row-Level Security for Distributed Tables

Support row-level security for Distributed tables. #8926 (Ivan)
Support for row-level security on Distributed tables in ClickHouse.

Why it matters

This feature enables row-level security to be enforced on Distributed tables, allowing users to control access to rows based on security policies even when querying distributed tables. It resolves the limitation where row-level security could not be applied on distributed setups, thereby enhancing data security and compliance in clustered environments.

How to use it

To apply row-level security on Distributed tables, define row-level security policies on the underlying local tables and ensure that the Distributed table queries respect these policies automatically. No additional configuration on the distributed table itself is needed once the policies are in place on the local tables.