1 Version 4.0 -- 1/15/89 sp_addgroup
______________________________________________________________________
NAME: sp_addgroup
FUNCTION:
Adds a group to a database. Groups are used as collective names
in granting and revoking privileges.
SYNTAX:
sp_addgroup grpname
EXAMPLES:
sp_addgroup accounting
sp_addgroup Version 4.0 -- 1/15/89 2
______________________________________________________________________
Creates a group named accounting.
PARAMETERS:
grpname - is the name of the group. Group names must follow the
rules for identifiers.
COMMENTS:
o Groups are used as collective names for granting and revoking
privileges.
o The sp_addgroup procedure adds an entry for the new group to a
database's sysusers table. Each group's uid is 16384 or larger
(except that the uid of the public group is always 0).
o Once a group has been created, you can use the group name as an
optional parameter to sp_adduser, to add the new user to a
group at the same time. To add an already existing user to a
group, use sp_changegroup.
3 Version 4.0 -- 1/15/89 sp_addgroup
______________________________________________________________________
o A user can be a member of only one group.
o Every database is created with a group named public. If a user
is not explicitly added to another group, he or she is a member
of the public group.
MESSAGES:
An entry for the group has been added to the current database's
sysusers table. Users may now be made members of the group
with the procedures sp_adduser or sp_changegroup.
The group name you supplied is already being used as a user name.
Choose another name to use as the grpname parameter.
The group name you supplied is already being used as a group
name. Choose another name to use as the grpname parameter.
PERMISSIONS:
Execute permission to Database Owner.
sp_addgroup Version 4.0 -- 1/15/89 4
______________________________________________________________________
TABLES USED:
sysusers
SEE ALSO:
sp_adduser, sp_changegroup, sp_dropgroup, sp_helpgroup, GRANT,
REVOKE