Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections

Dropping users, groups, and user-defined roles

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

**Table 14-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