Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

alter_group(7) [centos man page]

ALTER 
GROUP(7) PostgreSQL 9.2.7 Documentation ALTER GROUP(7) NAME
ALTER_GROUP - change role name or membership SYNOPSIS
ALTER GROUP group_name ADD USER user_name [, ... ] ALTER GROUP group_name DROP USER user_name [, ... ] 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 GRANT(7) or REVOKE(7). The third variant changes the name of the group. This is exactly equivalent to renaming the role with ALTER ROLE (ALTER_ROLE(7)). 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
GRANT(7), REVOKE(7), ALTER ROLE (ALTER_ROLE(7)) PostgreSQL 9.2.7 2014-02-17 ALTER GROUP(7)

Check Out this Related Man Page

ALTER 
CONVERSION(7) PostgreSQL 9.2.7 Documentation ALTER CONVERSION(7) NAME
ALTER_CONVERSION - change the definition of a conversion SYNOPSIS
ALTER CONVERSION name RENAME TO new_name ALTER CONVERSION name OWNER TO new_owner ALTER CONVERSION name SET SCHEMA new_schema DESCRIPTION
ALTER CONVERSION changes the definition of a conversion. You must own the conversion to use ALTER CONVERSION. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the conversion's schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the conversion. However, a superuser can alter ownership of any conversion anyway.) PARAMETERS
name The name (optionally schema-qualified) of an existing conversion. new_name The new name of the conversion. new_owner The new owner of the conversion. new_schema The new schema for the conversion. EXAMPLES
To rename the conversion iso_8859_1_to_utf8 to latin1_to_unicode: ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode; To change the owner of the conversion iso_8859_1_to_utf8 to joe: ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe; COMPATIBILITY
There is no ALTER CONVERSION statement in the SQL standard. SEE ALSO
CREATE CONVERSION (CREATE_CONVERSION(7)), DROP CONVERSION (DROP_CONVERSION(7)) PostgreSQL 9.2.7 2014-02-17 ALTER CONVERSION(7)
Man Page

15 More Discussions You Might Find Interesting

1. AIX

Max users in a group ?

Hi All, Does anyone know if there is a maximum limit to the number of users that can be assigned to a group. I currently have on a production server 900+ users in 1 group. I know some of these users are no longer valid as we only have 500 employees and not all employees use this application. ... (4 Replies)
Discussion started by: anmiller
4 Replies

2. UNIX for Dummies Questions & Answers

Sort cmd to get GROUP BY?

Is there any way using the sort command to get something like a GROUP BY clause? I'm trying to sort through race_event records and group them by those individuals that raced together in the same race on the same date at the same track, but i run into a problem when there were days when the track... (6 Replies)
Discussion started by: RacerX
6 Replies

3. Shell Programming and Scripting

checking Permissions of file for OTHERS and GROUP

Hi, Is their a way to check the read and execute permission on a file on OTHERS and GROUP rwxr--r-x I am trying something like: if ( || ) then .... fi The code above only checks the permissions of the owner of the file but not for the GROUP and OTHERS. I will really... (5 Replies)
Discussion started by: rkumar28
5 Replies

4. UNIX for Dummies Questions & Answers

Adding users question

Hello there, I want to add new users to my system, so, being logged in as root I do useradd -m user_name, and the new user is added to the system. The problem is that it has more privileges than I expected. If I do su user_name then I am allowed to do cat /etc/passwd , so it is... (4 Replies)
Discussion started by: help.goes.here
4 Replies

5. AIX

Security user Can't change the groups.

Dears Security users in AIX don’t have permission to change the group of the user thru Smitty Users When they try to change the group of the users to any group they'll get permission denied Security profile in Smitty : User... (10 Replies)
Discussion started by: ITHelper
10 Replies

6. Shell Programming and Scripting

Regular expression for group of users

Is it possible to create one regular expression to match a group of users, ignoring the order of the users. I have not been able to figure it out. If someone could nudge me in the right direction it would be appreciated. Sample data: Group 1 = Manny, Moe, Jack Group 2 = Moe,Jack,Manny... (3 Replies)
Discussion started by: viRaven
3 Replies

7. Shell Programming and Scripting

IF $USER is not in this list of users, then do this

I need to add to a BASH script if ${USER} is not in a list of users (smitha, brownd, adamsp) then do something... what is the best shortest way to accomplish an if statement with a list like this? Also the list of users should be in the script, not an external file. Thanks! (5 Replies)
Discussion started by: glev2005
5 Replies

8. UNIX for Dummies Questions & Answers

Discover the last user in a group to edit a file?

Alright, so a number of users are in a group, and they have certain access rights to a file, which is owned by a single user, standard stuff, right? However, I need to know which user in that group was the last user to edit a file. Is there any way to determine this in SunOS 5.9? I've looked... (5 Replies)
Discussion started by: rainedragon
5 Replies

9. Shell Programming and Scripting

Nested for loops

Greetings All, The following script attempts to enumerate all users in all groups in the group file(GROUP) and echo the following information: GROUP ---> USER The script is as follows: IFS="," for GROUP in `ypcat -k group | cut -d" " -f1` do for USER in `ypcat -k group... (13 Replies)
Discussion started by: jacksolm
13 Replies

10. Shell Programming and Scripting

Sorting group information for accounts

I have an input file that contains the primary and secondary groups a user should have based on a pre-defined role. The input file looks like this: <user_login>|<comment_field>|<role> After I execute my script to do some grepping I have the following user file where the secondary groups are... (10 Replies)
Discussion started by: MaindotC
10 Replies

11. Shell Programming and Scripting

Execute command with loop

I have a below command ALTER TABLE `abc` ADD PARTITION ( PARTITION 20130613 VALUES less than (DAY('13'))); Below is requirement It runs in Loop as DAY start with 13 and end with 100 along with this of counter "20130613" also increases per command as the next command should be ... (8 Replies)
Discussion started by: kaushik02018
8 Replies

12. UNIX for Dummies Questions & Answers

How to create a Group with rwx permission?

I want to create a GROUP with rwx permission. Also, I want to create a GROUP with root privileges, so that next time i create a user, I just need to add it to any of the groups and privileges automatically applied. please help. Thanks, Shouvanik (4 Replies)
Discussion started by: shouvanik
4 Replies

13. Shell Programming and Scripting

Subtotal in UNIX

Please help me on below req Data in file ARIZONA HCPAZ 47 ARIZONA HCPAZCONT 3056 ARIZONA AZA 20 CALIFORNIA HC06 878 CALIFORNIA LC04 51 CALIFORNIA LC06 4039 CALIFORNIA HCPCACONT 4960 THE CAMDEN GROUP CAM 83... (7 Replies)
Discussion started by: skchevva
7 Replies

14. UNIX for Dummies Questions & Answers

Check users in a Linux group

How do you check users in a linux group? (7 Replies)
Discussion started by: cokedude
7 Replies

15. Shell Programming and Scripting

Remove duplicate lines after ignoring case and spaces between

Oracle Linux 6.5 $ cat someStrings.txt GRANT select on MANHPRD.S_PROD_INT TO OR_PHIL; GRANT select on MANHPRD.S_PROD_INT TO OR_PHIL; GRANT select on SCOTT.emp to JOHN; grant select on scott.emp to john; grant select on scott.dept to hr;If you ignore the case and the empty space between the... (6 Replies)
Discussion started by: kraljic
6 Replies