Red Hat Database: SQL Guide and Reference
PrevNext

ALTER GROUP

Name

ALTER GROUP  --  Adds users to a group, removes 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

User who is 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 a group and a user: 
CREATE GROUP rhdbgroup1;
CREATE USER rhdb1;

To add a user to the group: 
ALTER GROUP rhdbgroup1 ADD USER rhdb1;
To remove the user from the group: 
ALTER GROUP rhdbgroup1 DROP USER rhdb1;
As mentioned in the description, removing a user from a group does not drop the user, so explicitly drop the user now (optionally, you can also drop the group to return the database to its initial state): 
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