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.
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 Parameter Description in ALTER ROLE.
Examples
1 2 3 4 5 6 7 8 |
-- Add users to a user group. openGauss=# ALTER GROUP super_users ADD USER lche, jim; -- Remove users from a user group. openGauss=# ALTER GROUP super_users DROP USER jim; -- Change the name of a user group. openGauss=# ALTER GROUP super_users RENAME TO normal_users; |
Helpful Links
CREATE GROUP, DROP GROUP, and ALTER ROLE
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot