USE master

if not exists (select * from sys.syslogins where name='qasUser')
CREATE LOGIN qasUser WITH PASSWORD = 'quadr8qas', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF, DEFAULT_DATABASE=QAS;
GO

USE QAS

if exists (select * from dbo.sysusers where name = N'qasUser' AND hasdbaccess = 1)
BEGIN
-- Revoke access here
exec sp_revokedbaccess 'qasUser';
END

-- Grant Access here
CREATE USER qasUser FOR LOGIN qasUser WITH DEFAULT_SCHEMA = db_owner;

EXEC sp_addrolemember 'db_owner', 'qasUser'

EXEC sp_addrolemember 'db_datareader', 'qasUser'

EXEC sp_addrolemember 'db_datawriter', 'qasUser'

EXEC master..sp_addsrvrolemember @loginame = N'qasUser', @rolename = N'dbcreator'

EXEC master..sp_addsrvrolemember @loginame = N'qasUser', @rolename = N'processadmin'
GO