-- LosaDev 2019: database users for the DB agent logins (db_owner, like the original service).
USE [LosaGame_log]
GO
IF USER_ID(N'lstggame') IS NULL CREATE USER [lstggame] FOR LOGIN [lstggame]
ALTER ROLE [db_owner] ADD MEMBER [lstggame]
GO
USE [Backup]
GO
IF USER_ID(N'lstggame') IS NULL CREATE USER [lstggame] FOR LOGIN [lstggame]
ALTER ROLE [db_owner] ADD MEMBER [lstggame]
GO
USE [LosaLogData]
GO
IF USER_ID(N'lstggame') IS NULL CREATE USER [lstggame] FOR LOGIN [lstggame]
ALTER ROLE [db_owner] ADD MEMBER [lstggame]
GO
IF USER_ID(N'lstglog') IS NULL CREATE USER [lstglog] FOR LOGIN [lstglog]
ALTER ROLE [db_owner] ADD MEMBER [lstglog]
GO
USE [LosaGame]
GO
IF USER_ID(N'lstggame') IS NULL CREATE USER [lstggame] FOR LOGIN [lstggame]
ALTER ROLE [db_owner] ADD MEMBER [lstggame]
GO