ALTER GROUP
Applies to: Databricks SQL 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).
Syntax
ALTER GROUP parent_principal { ADD | DROP }
{ GROUP group_principal [, ...] |
USER user_principal [, ...] } [...]
Parameters
-
The name of the workspace-local group to be altered.
-
A list of workspace-local subgroups to ADD or DROP.
-
A list of users to ADD or DROP.
Examples
-- Creates a group named `aliens` containing a user `alf@melmak.et`.
CREATE GROUP aliens WITH USER `alf@melmak.et`;
-- Alters the group and add `tv_aliens` as a member.
ALTER GROUP aliens ADD GROUP tv_aliens;
-- Alters the group aliens and drops `alf@melmak.et` as a member.
ALTER GROUP aliens DROP USER `alf@melmak.et`;
-- Alters the group tv_aliens and add `alf@melmak.et` as a member.
ALTER GROUP tv_aliens ADD USER `alf@melmak.et`;