v.21.9New Feature

Allow Setting Default Database for Users

Allow setting default database for users. #25268. #25687 (kevin wan).
Allows setting a default database for individual users in ClickHouse.

Why it matters

This feature enables assigning a specific default database to users, simplifying connection behavior by removing the need to specify the database explicitly in queries or connection parameters. It improves user experience and access management by providing a personalized default context for database operations.

How to use it

To set the default database for a user, configure the user's settings by specifying the desired default database name. For example, update the user's configuration with the default_database parameter to define their default database context.