SQL Server Create Login with User

create_db_user.sql

-- create a user myUser with myPassword and assign it to myDb

USE [master]
GO

-- Delete existing login.
IF  EXISTS (SELECT * FROM sys.server_principals WHERE name = N'myUser')
DROP LOGIN [myUser]
GO

-- Add new login.
CREATE LOGIN [myUser] WITH PASSWORD=N'myPassword', DEFAULT_DATABASE=[myDb]
GO

USE myDb
GO

IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'myUser')
DROP USER [myUser]
GO
 
-- Add new user.
CREATE USER [myUser] FOR LOGIN [myUser] WITH DEFAULT_SCHEMA=[STAGE]
GO

-- OPTIONAL if I want to make it admin
EXEC sp_addrolemember 'db_owner', 'myUser'
GO

EXEC sp_addrolemember 'db_datareader', 'myUser'
EXEC sp_addrolemember 'db_datawriter', 'myUser'
GO