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 syntax and not recommended. Users can use ALTER ROLE directly.

Syntax ​

• Add users to a group.

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

• Remove users from a group.

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

• Change the name of the group.

  ALTER GROUP group_name 
      RENAME TO new_name;

Parameter Description ​

See Parameter Description in ALTER ROLE.

Examples ​

-- Add users to a group.
openGauss=# ALTER GROUP super_users ADD USER lche, jim;

-- Remove users from a group.
openGauss=# ALTER GROUP super_users DROP USER jim;

-- Change the name of the group.
openGauss=# ALTER GROUP super_users RENAME TO normal_users;

Helpful Links ​

ALTER GROUP, DROP GROUP, and ALTER ROLE