v.23.8Improvement

Add Queries for Managing Access Entities in Access Storage

Add new queries, which allow to create/drop of access entities in specified access storage or move access entities from one access storage to another. #51912 (pufit).
Add new queries to manage access entities in specified access storages, including creation, deletion, and moving between storages in ClickHouse.

Why it matters

This feature introduces SQL queries that enable users to create, drop, and move access entities (such as users, roles, and quotas) within specified access storages. It improves flexibility and manageability of access control by allowing these operations across different access storages, facilitating better security and organization.

How to use it

Use the new SQL queries to manipulate access entities by specifying the target access storage. The queries allow creating and dropping access entities in a chosen storage, as well as moving entities from one access storage to another. These commands are executed within ClickHouse's SQL interface and require appropriate permissions.