CREATE USER

To CREATE a USER in a specific database use...

USE [mydatabase]

GO

CREATE USER [myuser] FOR LOGIN [mylogin]

GO

DROP USER

To DROP a USER from a specific database use...

USE [mydatabase]

GO

DROP USER myuser

GO

This can also be achieved in SSMS.