v.22.4New Feature
Add Simple Row Policies to ClickHouse
Add a new kind of row policies namedsimple. Before this PR we had two kinds or row policies:permissiveandrestrictive. Asimplerow policy adds a new filter on a table without any side-effects like it was for permissive and restrictive policies. #35345 (Vitaly Baranov).
Why it matters
Thesimple row policy provides a way to add a filter on a table without any side effects, unlike the permissive and restrictive policies. This allows more straightforward and predictable row-level filtering behavior.How to use it
Define a row policy with the kind set tosimple. This policy will apply a filter on the table without altering row visibility in side-effect ways, simplifying access control configuration.