1 Version 4.0 -- 1/15/89 sp_dropgroup
______________________________________________________________________
NAME: sp_dropgroup
FUNCTION:
Drops a group from a database.
SYNTAX:
sp_dropgroup grpname
EXAMPLES:
sp_changegroup accounting, martha
sp_changegroup "public", george
sp_dropgroup purchasing
sp_dropgroup Version 4.0 -- 1/15/89 2
______________________________________________________________________
The purchasing group has merged with the accounting group.
Members of the purchasing group, martha and george, are moved to
the accounting group or to the public group. Then the purchasing
group is dropped. The group name "public" is quoted because pub-
lic is a reserved word.
PARAMETERS:
grpname - is the name of a group in the current database.
COMMENTS:
o Executing sp_dropgroup drops a group name from a database's
sysusers table.
o You can't drop a group if it has members. You must execute
sp_changegroup for each member before you can drop the group.
3 Version 4.0 -- 1/15/89 sp_dropgroup
______________________________________________________________________
MESSAGES:
The group no longer exists in the current database.
The specified group doesn't exist.
The public group exists in every database. It is the group that
all users belong to by default, and cannot be dropped.
Groups with members can't be dropped. Reassign the members of
the group to another group using sp_changegroup. When this
error message is generated, a list of the group members is
displayed.
PERMISSIONS:
Execute permission to Database Owner.
TABLES USED:
sysobjects, sysusers
sp_dropgroup Version 4.0 -- 1/15/89 4
______________________________________________________________________
SEE ALSO:
sp_addgroup, sp_adduser, sp_changegroup, sp_dropuser,
sp_helpgroup, GRANT, REVOKE, USE