GNU/Linux |
CentOS 2.1AS(Slurm) |
|
![]() |
create_group(l) |
![]() |
CREATE GROUP − Creates a new group
CREATE GROUP
name
[ WITH
[ SYSID gid ]
[ USER username [, ...] ] ]
INPUTS
name |
The name of the group. | ||
gid |
The SYSID clause can be used to choose the Postgres group id of the new group. It is not necessary to do so, however. |
If this is not specified, the highest assigned group id plus one, starting at 1, will be used as default.
username
A list of users to include in the group. The users must already exist.
OUTPUTS
CREATE GROUP
Message returned if the command completes successfully.
CREATE GROUP will create a new group in the database installation. Refer to the adminstrator’s guide for information about using groups for authentication. You must be a database superuser to use this command.
Use ALTER GROUP [alter_group(l)] to change a group’s membership, and DROP GROUP [drop_group(l)] to remove a group.
Create an empty group:
CREATE GROUP staff
Create a group with members:
CREATE GROUP marketing WITH USER jonathan, david
SQL92
There is no CREATE GROUP statement in SQL92. Roles
are similar in concept to groups.
![]() |
create_group(l) | ![]() |