v.20.5Improvement

Show Authentication Type in Users Table and SHOW CREATE USER Query

Official CH changelog text
Show authentication type in table system.users and while executing SHOW CREATE USER query. #11080 (Vitaly Baranov).
Displays the authentication type for each user in the system.users table and in the output of the SHOW CREATE USER query.

Why it matters

This feature helps database administrators and users understand which authentication method is configured for each user, improving security management and auditing capabilities in ClickHouse.

How to use it

Simply query the system.users table or run the SHOW CREATE USER <user_name> command to see the authentication type associated with each user.

Related resources

PreviousNext