1 Version 4.0 -- 1/15/89 sp_changegroup
______________________________________________________________________
NAME: sp_changegroup
FUNCTION:
Changes a user's group.
SYNTAX:
sp_changegroup grpname, name_in_db
EXAMPLES:
sp_changegroup fort_mudge, albert
The user albert is now a member of the fort_mudge group. It
sp_changegroup Version 4.0 -- 1/15/89 2
______________________________________________________________________
doesn't matter what group albert belonged to before.
PARAMETERS:
grpname - is the name of the group. The group must already
exist in the current database.
name_in_db - is the name of the user to add to the group. The
user must already exist in the current database.
COMMENTS:
o Executing sp_changegroup adds the specified user to the speci-
fied group. The user is dropped from the group he or she
belongs to and added to the one specified by grpname.
o New database users can be added to groups at the same time they
are given access to the database with sp_adduser.
o Every user is a member of the default group, public, if he or
she has not been explicitly added to some other group with
3 Version 4.0 -- 1/15/89 sp_changegroup
______________________________________________________________________
sp_adduser or sp_changegroup.
o A user can be a member of only one group.
o Groups are used as a collective name for granting and revoking
privileges.
o If you use public as the grpname parameter, it must be enclosed
in quotes because it is a SQL keyword.
o To remove someone from a group, issue sp_changegroup "public",
name_in_db.
MESSAGES:
The user now belongs to the specified group.
The specified group doesn't exist in the current database.
The specified user doesn't exist in the current database.
PERMISSIONS:
sp_changegroup Version 4.0 -- 1/15/89 4
______________________________________________________________________
Execute permission to Database Owner.
TABLES USED:
sysusers
SEE ALSO:
sp_addgroup, sp_adduser, sp_dropgroup, sp_helpgroup, GRANT,
REVOKE