![]() |
#14 |
Участник
|
Таки нашел у себя скрипт.
X++: SET NOCOUNT ON -- automatically add admins DECLARE @RecId BIGINT DECLARE @RecCount INT CREATE TABLE #AdminUsers ( Id NVARCHAR(5) NOT NULL, SecId NVARCHAR(124) NOT NULL, Alias NVARCHAR(20) NOT NULL, Name NVARCHAR(40) NOT NULL, Email NVARCHAR(80) NOT NULL, Domain NVARCHAR(255) NOT NULL DEFAULT 'your-domain.com' ) CREATE NONCLUSTERED INDEX IX_ID ON #AdminUsers (Id) -- add admin users here: INSERT INTO #AdminUsers VALUES ('Vasya', 'S-1-5-21-3902653788-3936360043-4268998436-25184', 'PupkinV', 'Pupkin, Vasily', 'vasily.pupkin@your-domain.com', DEFAULT) SELECT @RecCount = COUNT(*) FROM #AdminUsers -- UserInfo EXEC ppoGetRecId 65531, @RecCount, @RecId OUTPUT DELETE UserInfo WHERE Id IN (SELECT Id FROM #AdminUsers) INSERT INTO UserInfo ([RecId], [Id], [Sid], [NetworkAlias], [NetworkDomain], [Company], [Enable], [Name], [Language], [HelpLanguage], [CompilerWarningLevel], [DebugInfo]) SELECT ROW_NUMBER() OVER(ORDER BY Id) - 1 + @RecId, [Id], [SecId], [Alias], [Domain], 'clt', 1, [Name], 'EN-US', 'EN-US', 4, 16 FROM #AdminUsers -- SysUserInfo EXEC ppoGetRecId 956, @RecCount, @RecId OUTPUT DELETE SysUserInfo WHERE Id IN (SELECT Id FROM #AdminUsers) INSERT INTO SysUserInfo (RecId, Id, HelpTheme, DocuHandlingActive, DocuToolbarButtonActive, EventPollFrequency, EventPopUps, Email) SELECT ROW_NUMBER() OVER(ORDER BY Id) - 1 + @RecId, [Id], 'Dynamics', 1, 0, 15, 1, [Email] FROM #AdminUsers -- UserGroupList EXEC ppoGetRecId 65529, @RecCount, @RecId OUTPUT DELETE UserGroupList WHERE UserId (SELECT Id FROM #AdminUsers) INSERT INTO UserGroupList (RecId, UserId, GroupId) SELECT ROW_NUMBER() OVER(ORDER BY Id) - 1 + @RecId, [Id], 'Admin' FROM #AdminUsers DROP TABLE #AdminUsers
__________________
// no comments |
|
|
За это сообщение автора поблагодарили: oleggy (1). |
|
|