v.25.5Improvement
Add access_control_improvements
Added access_control_improvements.enable_user_name_access_type setting. This setting allows enabling/disabling of precise grants for users/roles, introduced in https://github.com/ClickHouse/ClickHouse/pull/72246. You may want to turn this setting off in case you have a cluster with the replicas older than 25.1. #79842 (pufit).Why it matters
This setting addresses compatibility issues with clusters containing replicas running versions older than 25.1 by allowing administrators to disable precise grants for users and roles, ensuring smooth operation across mixed-version environments.How to use it
Set theaccess_control_improvements.enable_user_name_access_type setting to true to enable precise grants or false to disable them. This can be configured in the server settings or user profiles depending on the deployment scenario.