Red Hat Database: SQL Guide and Reference
PrevNext

ALTER GROUP

Name

ALTER GROUP  --  Add users to a group, remove users from a group

Synopsis

ALTER GROUP name ADD USER username [, ... ]
ALTER GROUP name DROP USER username [, ... ]

Inputs

name

The name of the group to modify.

username

Users who are to be added to or removed from the group. The user names must exist.

Outputs

ALTER GROUP

Message returned if the alteration was successful.

Description

ALTER GROUP is used to add or remove users from a group. Only database superusers can use this command. Adding a user to a group does not create the user. Similarly, removing a user from a group does not drop the user.

Notes

Use CREATE GROUP to create a new group and DROP GROUP to remove a group.

Use CREATE USER to create a new user and DROP USER to remove a user.

Usage 

CREATE GROUP rhdbgroup1;
CREATE USER rhdb1;

To add users to a group: 
ALTER GROUP rhdbgroup1 ADD USER rhdb1;
To remove a user from a group: 
ALTER GROUP rhdbgroup1 DROP USER rhdb1;
DROP USER rhdb1;
DROP GROUP rhdbgroup1;

Compatibility

SQL92

There is no ALTER GROUP statement in SQL92. The SQL concept of Roles is similar.

PrevHomeNext
ABORTUpALTER TABLE