ALTER ROLE [IF EXISTS] name1 [RENAME TO new_name |, name2 [,...]]
[ON CLUSTER cluster_name]
[DROP ALL PROFILES]
[DROP ALL SETTINGS]
[DROP PROFILES 'profile_name' [,...] ]
[DROP SETTINGS variable [,...] ]
[ADD|MODIFY SETTINGS variable [= value] [MIN [=] min_value] [MAX [=] max_value] [CONST|READONLY|WRITABLE|CHANGEABLE_IN_READONLY] | PROFILE 'profile_name'] [,...]
[ADD PROFILES 'profile_name' [,...] ]
ALTER ROLE
Documentation for Role
Changes roles.
Syntax:
Last modified on June 12, 2026