Password Type in CREATE USER Queries Automatically Set by default_password_type Configuration

Why it matters

This feature simplifies user management by automatically applying a default password hashing type when creating users without explicitly specifying the password type. It ensures consistent password policies and enhances security by relying on a centralized configuration.

How to use it

To use this feature, set the desired default password type in the default_password_type setting within the config.xml configuration file on the ClickHouse server. Then, when creating users with statements like CREATE USER u IDENTIFIED BY 'p', the password type will be automatically assigned based on that configuration.