21 lines
683 B
Transact-SQL
21 lines
683 B
Transact-SQL
-- LosaDev 2014: 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
|
|
USE [LosaGame]
|
|
GO
|
|
IF USER_ID(N'lstggame') IS NULL CREATE USER [lstggame] FOR LOGIN [lstggame]
|
|
ALTER ROLE [db_owner] ADD MEMBER [lstggame]
|
|
GO |