Share via


ALTER GROUP

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Alters a workspace-local group by either adding or dropping users and groups as members. Workspace-local groups are not synchronized to the Azure Databricks account and are not compatible with Unity Catalog. For more information, see Manage workspace-local groups (legacy).

To run this command you must be an administrator.

Syntax

ALTER GROUP parent_principal { ADD | DROP }
    { GROUP group_principal [, ...] |
      USER user_principal [, ...] } [...]

Parameters

Examples

-- Creates a group named `aliens` containing a user `[email protected]`.
CREATE GROUP aliens WITH USER `[email protected]`;

-- Alters the group and add `tv_aliens` as a member.
ALTER GROUP aliens ADD GROUP tv_aliens;

-- Alters the group aliens and drops `[email protected]` as a member.
ALTER GROUP aliens DROP USER `[email protected]`;

-- Alters the group tv_aliens and add `[email protected]` as a member.
ALTER GROUP tv_aliens ADD USER `[email protected]`;