24 lines
805 B
Transact-SQL
24 lines
805 B
Transact-SQL
-- 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 |