v.21.9New Feature

Add default_database column to system.users

Add column default_database to system.users. #27054 (kevin wan).
Added a new column default_database to the system.users table in ClickHouse.

Why it matters

This feature provides visibility into the default database configured for each user, allowing administrators to easily query and manage user default database settings directly from the system tables.

How to use it

Query the system.users table to see the default_database column alongside other user details. For example:

SELECT name, default_database FROM system.users;