CREATE GROUP
Creates
a new group.
SYNTAX
| group_name |
Name
of the new group you want to create. |
DESCRIPTION
The CREATE
GROUP command creates a new user group. Users in this group will gain
all object privileges that are granted to the group. Only users with SYSADM
or DBA user privileges can execute the CREATE GROUP command.
Groups are
used to simplify the management of object privileges in a database with
a large number of users. You can use a group to collect together all users
who require the same object privileges. Any object privileges you grant
to the group will automatically be granted to all members of the group.
After creating a new group you can add users to the group using the ADD
TO GROUP command.
DBMaker
also provides support for nested groups. You can add a group as a member
of another group, provided there are no circular references from the group
you are adding to the other group, and provided you are not trying to
add a group to itself. For example, you cannot add group1 as a member
of group2 if group2 is already a member of group1, and you cannot add
group 1 as a member of itself. You can add a group as a member of another
group in exactly the same way as you add a user to a group.
The group
name cannot be SYSTEM, PUBLIC, or GROUP, and cannot be the same as any
existing user or group names. Group names have a maximum length of eight
characters, and may contain letters, numbers, the underscore character,
and the symbols $ and #. The first character may not be a number.
EXAMPLE
The following
example creates a new group named Employees.
RELATED COMMANDS
<
CREATE DOMAIN | Contents
| CREATE INDEX >
|
