ADD TO GROUP
Adds a user
to a group.
SYNTAX
| user_name |
Name
of an existing user that has connect privilege (or higher) on the
database. |
| group_name |
Name
of an existing group. |
DESCRIPTION
The ADD
TO GROUP command adds a user to an existing group. The user will gain
all current and future object privileges that have been granted to the
group. Only users with SYSADM or DBA user privileges can execute the ADD
TO 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 add does not contain a reference to the group you are
adding it to. 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 adds users Joe and John into the Manager group.
dmSQL>
ADD Joe, John TO GROUP Manager |
The following
example adds groups FullTime and PartTime into the Staff group.
dmSQL>
ADD FullTime, PartTime TO GROUP Staff |
The following
example adds user Bill and group FlexTime into the Staff group.
dmSQL>
ADD Bill, FlexTime TO GROUP Staff |
RELATED COMMANDS
<
ABORT BACKUP | Contents
| ALTER DATAFILE >
|
