v.23.5Improvement
Adding Roles Field to users.xml for Configurable Permissions
Adding the roles field in the users.xml file, which allows specifying roles with grants via a config file. #50278 (pufit).
Why it matters
This feature enables administrators to define user roles and associated access grants via configuration files, simplifying and centralizing user access management without relying solely on SQL commands.How to use it
Edit theusers.xml file and add the roles field under a user entry to specify roles and grants. After updating the configuration file, restart ClickHouse or reload settings to apply the changes.