v.20.5Improvement

Multiple Names Allowed in User and Role Commands

Official CH changelog text
Multiple names are now allowed in commands: CREATE USER, CREATE ROLE, ALTER USER, SHOW CREATE USER, SHOW GRANTS and so on. #11670 (Vitaly Baranov).
Multiple names can now be specified in various user and role management commands such as CREATE USER, CREATE ROLE, ALTER USER, SHOW CREATE USER, and SHOW GRANTS.

Why it matters

This feature improves administrative efficiency by allowing batch operations on multiple users or roles in a single command, reducing repetitive statements and simplifying permission management.

How to use it

To use this feature, specify multiple user or role names separated by commas in the respective commands. For example:

CREATE USER user1, user2, user3;
ALTER USER user1, user2 SETTINGS ...;
SHOW GRANTS FOR user1, user2;

Related resources

PreviousNext