Create login and user (MSSQL)

USE [master]

GO

CREATE LOGIN [ig] WITH PASSWORD=N'ig111!', DEFAULT_DATABASE=[ItaiTest], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON

GO

USE [ItaiTest]

GO

CREATE USER [ig] FOR LOGIN [ig]

GO

USE [ItaiTest]

GO

EXEC sp_addrolemember N'db_owner', N'ig'

GO