Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- :SETVAR DatabasePrefix xp0
- :SETVAR UserName collectionuser
- :SETVAR Password Test12345
- :SETVAR ShardMapManagerDatabaseNameSuffix _Xdb.Collection.ShardMapManager
- :SETVAR Shard0DatabaseNameSuffix _Xdb.Collection.Shard0
- :SETVAR Shard1DatabaseNameSuffix _Xdb.Collection.Shard1
- GO
- IF(SUSER_ID('$(UserName)') IS NULL)
- BEGIN
- CREATE LOGIN [$(UserName)] WITH PASSWORD = '$(Password)'; END;
- GO
- USE [$(DatabasePrefix)$(ShardMapManagerDatabaseNameSuffix)]
- IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'$(UserName)') BEGIN
- CREATE USER [$(UserName)] FOR LOGIN [$(UserName)]
- GRANT SELECT ON SCHEMA :: __ShardManagement TO [$(UserName)] GRANT EXECUTE ON SCHEMA :: __ShardManagement TO [$(UserName)] END;
- GO
- USE [$(DatabasePrefix)$(Shard0DatabaseNameSuffix)]
- IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'$(UserName)') BEGIN
- CREATE USER [$(UserName)] FOR LOGIN [$(UserName)]
- EXEC [xdb_collection].[GrantLeastPrivilege] @UserName = '$(UserName)' END;
- GO
- USE [$(DatabasePrefix)$(Shard1DatabaseNameSuffix)]
- IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'$(UserName)') BEGIN
- CREATE USER [$(UserName)] FOR LOGIN [$(UserName)]
- EXEC [xdb_collection].[GrantLeastPrivilege] @UserName = '$(UserName)' END;
- GO
Add Comment
Please, Sign In to add comment