USE QFM164UATVentiaSEQ
GO
CREATE USER [swgsqlsupport] FOR LOGIN [swgsqlsupport]
GO

ALTER USER [swgsqlsupport] WITH DEFAULT_SCHEMA=[dbo]
GO

ALTER ROLE [db_backupoperator] ADD MEMBER [swgsqlsupport]
GO

ALTER ROLE [db_owner] ADD MEMBER [swgsqlsupport]
GO


CREATE USER [swgsqlps] FOR LOGIN [swgsqlps]
GO

ALTER USER [swgsqlps] WITH DEFAULT_SCHEMA=[dbo]
GO

ALTER ROLE [db_owner] ADD MEMBER [swgsqlps]
GO