v.23.8New Feature

Added max_sessions_for_user Setting

Added max_sessions_for_user setting. #51724 (Alexey Gerasimchuck).
Added the max_sessions_for_user setting to control the maximum number of concurrent sessions allowed per user in ClickHouse.

Why it matters

This feature limits the number of active sessions a user can have simultaneously, preventing resource overuse and improving system stability and security by mitigating excessive session creation.

How to use it

Set the max_sessions_for_user parameter in the server configuration or via SQL using SET max_sessions_for_user = <number> to define the maximum allowed concurrent sessions per user.