1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="sql-commands.html"><LINK
18
TITLE="ALTER FUNCTION"
19
HREF="sql-alterfunction.html"><LINK
22
HREF="sql-alterindex.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="ALTER FUNCTION"
57
HREF="sql-alterfunction.html"
66
TITLE="ALTER FUNCTION"
67
HREF="sql-alterfunction.html"
81
HREF="sql-alterindex.html"
90
HREF="sql-alterindex.html"
101
NAME="SQL-ALTERGROUP"
111
>ALTER GROUP -- change role name or membership</DIV
113
CLASS="REFSYNOPSISDIV"
167
> changes the attributes of a user group.
168
This is an obsolete command, though still accepted for backwards
169
compatibility, because groups (and users too) have been superseded by the
170
more general concept of roles.
173
> The first two variants add users to a group or remove them from a group.
174
(Any role can play the part of either a <SPAN
181
> for this purpose.) These variants are effectively
182
equivalent to granting or revoking membership in the role named as the
186
>; so the preferred way to do this is to use
188
HREF="sql-grant.html"
192
HREF="sql-revoke.html"
197
> The third variant changes the name of the group. This is exactly
198
equivalent to renaming the role with
200
HREF="sql-alterrole.html"
226
> The name of the group (role) to modify.
238
> Users (roles) that are to be added to or removed from the group.
239
The users must already exist; <TT
243
create or drop users.
255
> The new name of the group.
269
> Add users to a group:
272
CLASS="PROGRAMLISTING"
273
>ALTER GROUP staff ADD USER karl, john;</PRE
276
Remove a user from a group:
279
CLASS="PROGRAMLISTING"
280
>ALTER GROUP workers DROP USER beth;</PRE
296
> statement in the SQL
308
HREF="sql-grant.html"
311
HREF="sql-revoke.html"
314
HREF="sql-alterrole.html"
322
SUMMARY="Footer navigation table"
333
HREF="sql-alterfunction.html"
351
HREF="sql-alterindex.html"
367
HREF="sql-commands.html"
b'\\ No newline at end of file'