Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> ALTER GROUP
View PDF

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 Parameter Description in ALTER ROLE.

Helpful Links

CREATE GROUP, DROP GROUP, ALTER ROLE

Parent topic: DDL Syntax