Microsoft SQL Server

-- Create a service account
CREATE LOGIN artie_transfer WITH PASSWORD = 'AStrongPassword!';
GO

USE database;
GO

CREATE USER artie_transfer FOR LOGIN artie_transfer;
GO

-- If it's not dbo, change the schema name
GRANT ALTER ON SCHEMA::dbo TO artie_transfer;
GO

GRANT CREATE TABLE, INSERT, UPDATE, DELETE TO artie_transfer;
GO