sp_dropgroup

Syntax

sp_dropgroup grpname

Example 1 – The “purchasing” group has merged with the “accounting” group. These commands move “martha” and “george”, members of the “purchasing” group, to other groups before dropping the group. The group name “public” is quoted because “public” is a reserved word:
```
sp_changegroup accounting, martha 
sp_changegroup "public", george 
sp_dropgroup purchasing
```

Executing sp_dropgroup drops a group name from a database’s sysusers table.

You cannot drop a group if it has members. To drop the group, execute sp_changegroup for each member first.

The permission checks for sp_dropgroup differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage any user` privilege.
Disabled	With granular permissions disabled, you must be the database owner, a user with sa_role , or a user with sso_role.

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect