v.19.7New Features

Allow to Limit the Range of a Setting That Can Be Specified by User

Allow to limit the range of a setting that can be specified by user. These constraints can be set up in user settings profile. #4931 (Vitaly Baranov)
Introduces the ability to limit the range of values for ClickHouse settings that users can specify, by defining constraints within user settings profiles.

Why it matters

This feature enhances security and operational stability by preventing users from setting configuration options outside approved ranges. It ensures administrators can enforce boundaries on settings at the user profile level, reducing risks related to misconfiguration.

How to use it

Administrators can define constraints on settings within user settings profiles by specifying allowable value ranges. These constrained profiles are then assigned to users, restricting the settings they can apply to values within the configured limits.