Help Center > > Developer Guide> SQL Reference> SQL Syntax> ALTER GROUP

ALTER GROUP

Updated at: Mar 13, 2020 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel