CREATE SETTINGS PROFILE

Creates settings profiles that can be assigned to a user or a role.

Syntax:

ON CLUSTER clause allows creating settings profiles on a cluster, see Distributed DDL.

Example

Create a user:

Create the max_memory_usage_profile settings profile with value and constraints for the max_memory_usage setting and assign it to user robin: