v.23.4New Feature

Allow Creating Users with Current User's Grants Using GRANT CURRENT GRANTS

Official CH changelog text
Allow to easily create a user with the same grants as the current user by using GRANT CURRENT GRANTS. #48262 (pufit).
Introduces the ability to create a user with the same grants as the current user using the GRANT CURRENT GRANTS syntax.

Why it matters

This feature simplifies the process of duplicating user privileges by allowing administrators to quickly grant all the current user's privileges to another user without manually specifying each grant, saving time and reducing errors.

How to use it

Use the command GRANT CURRENT GRANTS TO <new_user> to grant the new user the exact same permissions as the current user.

Related resources

PreviousNext