v.23.5New Feature

Adding grants field in users.xml for user permissions

Adding the grants field in the users.xml file, which allows specifying grants for users. #49381 (pufit).
Introduces the grants field in the users.xml configuration file to specify user grants directly.

Why it matters

This feature allows database administrators to define user grants within the users.xml file, centralizing user permissions management and simplifying access control configuration for ClickHouse users.

How to use it

In the users.xml file, add the grants field under the relevant user section to declare the permissions granted to that user. The configuration will be applied when ClickHouse loads the user settings.