Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

ALTER GROUP

Name

ALTER GROUP -- Modifies the structure of a user group.

Synopsis

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

Parameters

name

The name of an existing group to alter.

username

The names of existing users you wish to add or remove from the specified group. Multiple names are delimited by commas.

Results

ALTER GROUP

The message returned when an ALTER GROUP modification is successful.

Description

Database superusers can use the ALTER GROUP command to add and remove specified users from a group. As groups can be allocated privileges, adding members to a group grants those privileges by proxy. Users must exist before they can be added to a group. Dropping a user from a group does not drop a user from the system.

Use CREATE GROUP to create a new group and DROP GROUP to remove a group. Use GRANT and REVOKE to manage privileges on a group.

Examples

The following example adds the PostgreSQL database users jessica and william to the sales group:

booktown=# 
ALTER GROUP sales ADD USER jessica, william;

ALTER

The next example removes the user jessica from the sales group:

booktown=# 
ALTER GROUP sales DROP USER jessica;

ALTER
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire