Dropping users, groups and user-defined roles

Table 10-5 list the system procedures that allow a System Administrator or Database Owner to drop users and groups.

**Table 10-5: Dropping users and groups**
Task	Required role	System procedure	Database
Drop user from database	Database Owner or System Administrator	sp_dropuser	User database
Drop group from database	Database Owner or System Administrator	sp_dropgroup	User database