CREATE LOGIN bob WITH PASSWORD='m8b#5pL'
GO

USE PUBS
GO

CREATE USER pubsbob FOR LOGIN bob
GO
-- the following will fail, login bob
-- may only have a single user in a database
CREATE USER otherPubsBob FOR LOGIN bob