v.25.11Improvement
Roles defined in SQL can now be
Roles defined in SQL can now be granted to users defined in users.xml. #88139 (c-end).Why it matters
This feature enables integration between SQL-defined roles and users managed through theusers.xml configuration file. It simplifies user privilege management by allowing roles created via SQL to be assigned directly to users configured outside of the SQL environment, enhancing security and administrative flexibility.How to use it
Define roles using SQL commands, such asCREATE ROLE, and then assign these roles to users configured in users.xml by specifying the roles in the user's configuration under the roles parameter. This allows users defined in users.xml to inherit the privileges of the SQL roles.