SQL Server - Create User And Assign To A Database

create_user_for_database.sql

USE [master]
GO

/* create login */
CREATE LOGIN [dbuser] WITH PASSWORD=N'password', 
DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO

USE [database_name]

/* create user */
CREATE USER [dbuser] FOR LOGIN [dbuser]
GO

/* assign role to a database */
EXEC sp_addrolemember N'db_ddladmin', N'dbuser'
EXEC sp_addrolemember N'db_datawriter', N'dbuser'
EXEC sp_addrolemember N'db_datareader', N'dbuser'
GO