v.25.3Improvement
Add PROFILES a, DROP ALL PROFILES because
This PR makes it impossible to run a queryALTER USER user1 ADD PROFILES a, DROP ALL PROFILESbecause allDROPoperations should come first in the order. #76242 (pufit).
Why it matters
This feature prevents ambiguous or conflicting behavior in user profile modifications by enforcing a clear and consistent ordering rule in theALTER USER command. It ensures that profile removals happen before additions, which improves query reliability and predictability.How to use it
When using theALTER USER query to modify user profiles, make sure to list all DROP PROFILE operations first, followed by any ADD PROFILE operations. For example:ALTER USER user1 DROP PROFILE profile1, ADD PROFILE profile2;