DROP GROUP
Removes
a group from the database.
SYNTAX
| group_name |
Name
of the group you want to remove from the database. |
DESCRIPTION
The DROP
GROUP command removes an existing group from the database. Only users
with SYSADM or DBA user privileges can execute the DROP 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.
DBMaker also provides support for nested groups, where you can have a
group as a member of another group, provided there are no circular references
from the member group to the other group.
When you
remove a group from a database, all members of the group will lose any
privileges granted to that group. They will retain any privileges granted
to them directly or to any other groups they are members of. You cannot
remove the PUBLIC group; this group is managed internally by DBMaker.
EXAMPLE
The following
example removes the group named Employees from the database.
RELATED COMMANDS
<
DROP DOMAIN | Contents
| DROP INDEX >
|
