CREATE LOGIN artie_transfer WITH PASSWORD = 'AStrongPassword!';
GO
USE database;
GO
CREATE USER artie_transfer FOR LOGIN artie_transfer;
GO
GRANT ALTER ON SCHEMA::dbo TO artie_transfer;
GO
GRANT CREATE TABLE, INSERT, UPDATE, DELETE TO artie_transfer;
GO