v.22.5Improvement

Implemented New Row Policy Handling Mode in Main Configuration

Implemented a new mode of handling row policies which can be enabled in the main configuration which enables users without permissive row policies to read rows. #36997 (Vitaly Baranov).
Introduces a new mode for handling row policies that allows users without permissive row policies to read rows.

Why it matters

This feature solves the problem where users restricted by row policies cannot access rows unless explicitly permitted. It enhances usability by enabling users to read rows even without permissive row policies, improving flexibility in access control.

How to use it

Enable the new row policy handling mode by configuring it in the main ClickHouse server configuration file. Once enabled, users without permissive row policies will be able to read rows according to the new mode.