Adds one or more users to a group.
ALTER GROUP <name> ADD USER <user1> [, <user2> ...]## Overview ALTER GROUP ADD USER adds users to a group's membership list. Each added user immediately gains every role assigned to the group (and through inheritance, every privilege those roles confer). ## Behavior - The group must already exist. The Control Plane validates existence and rejects ADD USER on an unknown group. - The keyword is `USER` (singular) followed by a comma-separated list of names. The same statement adds all listed users in one transaction at the Control Plane. - Adding a user that is already a member is a no-op; the catalog does not store duplicates. - The Control Plane resolves user names against the user catalog. The behavior when a listed user does not exist is determined by the Control Plane API; the SQL parser does not pre-validate user existence. ## Access Control Requires the `ManageUsers` privilege. ## Compatibility DeltaForge extension. Note the syntax uses `ADD USER <list>`, not `ADD USERS (<list>)`; the keyword is singular and parentheses are not required.
| Name | Type | Description |
|---|---|---|
name | Specifies the group to update. Must already exist. | |
users | Specifies one or more users to add. Multiple users are comma-separated. |
-- Add a single user
ALTER GROUP platform_team ADD USER alice;-- Add multiple users in one statement
ALTER GROUP platform_team ADD USER alice, bob, carol;