Updated on 2023-04-03 GMT+08:00

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.