Adds a group to a database. Groups are used as collective names in granting and revoking privileges.
is the name of the group. Group names must conform to the rules for identifiers.
Creates a group named accounting in the current database:
sp_addgroup adds the new group to a database’s sysusers table. Each group’s user ID (uid) is 16384 or larger (except “public,” which is always 0).
A group and a user cannot have the same name.
Every database is created with a group named “public”. Every user is automatically a member of “public”. Each user can be a member of one additional group.
Only the Database Owner, a System Administrator, or a System Security Officer can execute sp_addgroup.
Commands grant, revoke
System procedures sp_adduser, sp_changegroup, sp_dropgroup, sp_helpgroup