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).
Roles defined in SQL can now be granted to users defined in users.xml.

Why it matters

This feature enables integration between SQL-defined roles and users managed through the users.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 as CREATE 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.