ALTER GROUP

适用于:勾选“是” Databricks SQL 勾选“是” Databricks Runtime

通过将用户和组作为成员添加或删除来更改工作区本地组。 工作区本地组未同步到 Azure Databricks 帐户,并且与 Unity Catalog 不兼容。 有关详细信息,请参阅管理工作区本地组(旧版)

语法

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

参数

示例

-- 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`;