A system administrator, system security officer, or database owner can use sp_dropuser or sp_dropgroup to drop users and groups from databases.
