REMOVE FROM GROUP
Removes
a user from a group.
SYNTAX
| user_name |
Name
of the user you want to remove from the group. |
| group_name |
Name
of the group you want to remove the user from. |
DESCRIPTION
The REMOVE
FROM GROUP command removes a user from an existing group. The user will
lose all object privileges that have been granted to the group but have
not been granted explicitly to the user. Only users with SYSADM or DBA
user privileges can execute the REMOVE FROM 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 several
users and/or groups. Any object privileges you grant to the group will
automatically be granted to all members of the group.
Members
added to a group after object privileges have been granted will gain those
object privileges in addition to the object privileges that have been
granted to them directly. Members removed from a group will lose object
privileges that have been granted to the group, but will retain any privileges
that have been granted to them directly.
You can
also specify a group name in place of the user name, as long as the group
you are trying to remove. User and 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.
EXAMPLES
The following
example removes the user named Vivian from the group SalesStaff.
REMOVE Vivian FROM GROUP SalesStaff
|
The following
example removes the group named NYSalesStaff from the group named SalesStaff.
REMOVE NYSalesStaff FROM GROUP SalesStaff
|
RELATED COMMANDS
<
REBUILD TEXT INDEX | Contents
| REVOKE (Execute Privileges) >
|
