ALTER GROUP(7) SQL Commands ALTER GROUP(7)NAME
ALTER GROUP - change role name or membership
SYNOPSIS
ALTER GROUP groupname ADD USER username [, ... ]
ALTER GROUP groupname DROP USER username [, ... ]
ALTER GROUP groupname RENAME TO newname
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 [grant(7)] or REVOKE [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
groupname
The name of the group (role) to modify.
username
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.
newname
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 [grant(7)], REVOKE [revoke(7)], ALTER ROLE [alter_role(7)]
SQL - Language Statements 2010-05-14 ALTER GROUP(7)
Check Out this Related Man Page
ALTER TABLESPACE(7) SQL Commands ALTER TABLESPACE(7)NAME
ALTER TABLESPACE - change the definition of a tablespace
SYNOPSIS
ALTER TABLESPACE name RENAME TO newname
ALTER TABLESPACE name OWNER TO newowner
DESCRIPTION
ALTER TABLESPACE changes the definition of a tablespace.
You must own the tablespace to use ALTER TABLESPACE. To alter the owner, you must also be a direct or indirect member of the new owning
role. (Note that superusers have these privileges automatically.)
PARAMETERS
name The name of an existing tablespace.
newname
The new name of the tablespace. The new name cannot begin with pg_, as such names are reserved for system tablespaces.
newowner
The new owner of the tablespace.
EXAMPLES
Rename tablespace index_space to fast_raid:
ALTER TABLESPACE index_space RENAME TO fast_raid;
Change the owner of tablespace index_space:
ALTER TABLESPACE index_space OWNER TO mary;
COMPATIBILITY
There is no ALTER TABLESPACE statement in the SQL standard.
SEE ALSO
CREATE TABLESPACE [create_tablespace(7)], DROP TABLESPACE [drop_tablespace(7)]
SQL - Language Statements 2010-05-14 ALTER TABLESPACE(7)
Hi All,
I really need a help on this thing. Most of us are aware about the group by function in Oracle. Do we have a substitute ( not necessarily a single line command) to it in Unix?
Let me put it this way.
I have a file whose content is like
file1-:
ID1,ID2,ID3,ID4,ID5
1,2,3,123,5... (3 Replies)
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)
Hi,
I've mistakenly removed user id from HP Unix server.
I've removed using SAM
Now i need to resotre/recreat the removed user id (with same uid,group and username), How can i do that.
Thanks in Advance (3 Replies)
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)
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)
I have two files:
FileA:
INGROUP GROUP
xyz, abc
tst, def
dev, ghi
prd, jkl
FileB
GROUP ID
abc, developer
def, tester
ghi, integrator
jkl, analyst
I want the following output
File C (15 Replies)
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)
Im trying to put all the groups in into a variable called $GROUP, however in /etc/group there are also lotsa users. And the GID of group can differ as it can be set, this there is no specific range, how can i put all the names of the groups into that variable? (3 Replies)
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)
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)
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)
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)
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)
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)
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)