sp_adduser and sp_dropuser exists only for backward compatibility, so it is recommended to use sp_grantdbaccess and sp_revokedbaccess respectively instead. Both sets are used for managing existing login accounts access to databases. There are some differences in what they can do, but since sp_adduser might be removed in the future you should use sp_grantdbaccess.