Table 14-5 list the system procedures that allow a system administrator, system security officer, or database owner to drop users and groups.
Task |
Required authority |
System procedure |
Database |
|---|---|---|---|
Drop user from database |
Database owner, system security officer, or system administrator |
sp_dropuser |
User database |
Drop group from database |
Database owner, system security officer, or system administrator |
sp_dropgroup |
User database |
