v.21.9Improvement

Changing Default Roles Affects New Sessions Only

Changing default roles affects new sessions only. #26759 (Vitaly Baranov).
Changing default roles now affects only new sessions in ClickHouse.

Why it matters

This feature ensures that modifications to default roles do not impact existing sessions, preventing unexpected permission changes during active connections and improving session stability and security management.

How to use it

When you change default roles using ClickHouse role management commands, the changes will only apply to sessions started after the modification. Existing sessions retain their originally assigned roles until they reconnect or start a new session.