From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/alter_group.sgml | 134 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 134 insertions(+) create mode 100644 doc/src/sgml/ref/alter_group.sgml (limited to 'doc/src/sgml/ref/alter_group.sgml') diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml new file mode 100644 index 0000000..39cc2b8 --- /dev/null +++ b/doc/src/sgml/ref/alter_group.sgml @@ -0,0 +1,134 @@ + + + + + ALTER GROUP + + + + ALTER GROUP + 7 + SQL - Language Statements + + + + ALTER GROUP + change role name or membership + + + + +ALTER GROUP role_specification ADD USER user_name [, ... ] +ALTER GROUP role_specification DROP USER user_name [, ... ] + +where role_specification can be: + + role_name + | CURRENT_USER + | SESSION_USER + +ALTER GROUP group_name RENAME TO new_name + + + + + Description + + + ALTER GROUP changes the attributes of a user group. + This is an obsolete command, though still accepted for backwards + compatibility, because groups (and users too) have been superseded by the + more general concept of roles. + + + + The first two variants add users to a group or remove them from a group. + (Any role can play the part of either a user or a + group for this purpose.) These variants are effectively + equivalent to granting or revoking membership in the role named as the + group; so the preferred way to do this is to use + or + . + + + + The third variant changes the name of the group. This is exactly + equivalent to renaming the role with + . + + + + + Parameters + + + + group_name + + + The name of the group (role) to modify. + + + + + + user_name + + + Users (roles) that are to be added to or removed from the group. + The users must already exist; ALTER GROUP does not + create or drop users. + + + + + + new_name + + + The new name of the group. + + + + + + + + Examples + + Add users to a group: + + +ALTER GROUP staff ADD USER karl, john; + + + Remove a user from a group: + + +ALTER GROUP workers DROP USER beth; + + + + + Compatibility + + + There is no ALTER GROUP statement in the SQL + standard. + + + + + See Also + + + + + + + + + -- cgit v1.2.3