CREATE USER username FROM LOGIN login;

EXEC sp_addrolemember 'db_datareader', 'username';

EXEC sp_addrolemember 'db_datawriter', 'username';

EXEC sp_addrolemember 'db_ddladmin', 'username';