Lu, Huayi e6fa411af0 DWS DEV 830.201 version

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:24:04 +00:00

4.8 KiB

Raw Permalink Blame History

ALTER GROUP

Function

ALTER GROUP modifies the attributes of a user group.

Precautions

ALTER GROUP is an alias for ALTER ROLE, and it is not a standard SQL command and not recommended. Users can use ALTER ROLE directly.

Syntax

Add users to a group.

1
2
ALTER GROUP group_name 
    ADD USER user_name [, ... ];

Remove users from a group.

1
2
ALTER GROUP group_name 
    DROP USER user_name [, ... ];

Change the name of the group.

1
2
ALTER GROUP group_name 
    RENAME TO new_name;

Parameter Description

See the Example in ALTER ROLE.

Helpful Links

CREATE GROUP, DROP GROUP, ALTER ROLE

Parent topic: DDL Syntax

4.8 KiB Raw Permalink Blame History