Codeunit 104042 Upgrade Permission Sets
src/Layers/W1/BaseApp/OtherCapabilities/Upgrade/UpgradePermissionSets.Codeunit.al124 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Upgrade;using System.Environment;using System.Environment.Configuration;using System.Security.AccessControl;using System.Upgrade;/// <summary>/// Upgrade code to fix references of obsolete permission sets./// </summary>codeunit 104042 "Upgrade Permission Sets"{ Subtype = Upgrade; trigger OnUpgradePerDatabase() begin RunUpgrade(); end; internal procedure RunUpgrade() var HybridDeployment: Codeunit "Hybrid Deployment"; begin if not HybridDeployment.VerifyCanStartUpgrade('') then exit; ReplaceObsoletePermissionSets(); ReplaceObsoletePermissionSetsForEditInExcel(); end; local procedure ReplaceObsoletePermissionSetsForEditInExcel() var UpgradeTag: Codeunit "Upgrade Tag"; UpgradeTagDefinitions: Codeunit "Upgrade Tag Definitions"; begin if UpgradeTag.HasUpgradeTag(UpgradeTagDefinitions.GetUpdateEditInExcelPermissionSetUpgradeTag()) then exit; ReplacePermissionSet('EXCEL EXPORT ACTION', 'Edit in Excel - View'); UpgradeTag.SetUpgradeTag(UpgradeTagDefinitions.GetUpdateEditInExcelPermissionSetUpgradeTag()); end; local procedure ReplaceObsoletePermissionSets() var ServerSettings: Codeunit "Server Setting"; begin // Run the upgrade code only if the new permission system is enabled (permissions sets come from extensions) if not ServerSettings.GetUsePermissionSetsFromExtensions() then exit; ReplacePermissionSet('EMAIL SETUP', 'Email - Admin'); ReplacePermissionSet('EMAIL USAGE', 'Email - Edit'); ReplacePermissionSet('D365 EXTENSION MGT', 'Exten. Mgt. - Admin'); ReplacePermissionSet('RETENTION POL. SETUP', 'Retention Pol. Admin'); end; local procedure ReplacePermissionSet(OldPermissionSet: Code[20]; NewPermissionSet: Code[20]) var OldAccessControl, NewAccessControl, CurrentAccessControl : Record "Access Control"; OldUserGroupPermissionSet, NewUserGroupPermissionSet, CurrentUserGroupPermissionSet : Record "User Group Permission Set"; OldUserGroupAccessControl, NewUserGroupAccessControl, CurrentUserGroupAccessControl : Record "User Group Access Control"; AggregatePermissionSet: Record "Aggregate Permission Set"; begin AggregatePermissionSet.SetRange(Scope, AggregatePermissionSet.Scope::System); AggregatePermissionSet.SetRange("Role ID", NewPermissionSet); if not AggregatePermissionSet.FindFirst() then begin Session.LogMessage('0000FGT', StrSubstNo(NewPermissionSetNotFoundTxt, OldPermissionSet, NewPermissionSet), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', TelemetryCategoryTxt); exit; end; // User Groups need to be updated first as they result in modifications to Access Control // Change the User Group Permission Set entries that point to the old permission set to point to the new one OldUserGroupPermissionSet.SetRange("Role ID", OldPermissionSet); if OldUserGroupPermissionSet.FindSet() then repeat CurrentUserGroupPermissionSet.Get(OldUserGroupPermissionSet.RecordId()); if NewUserGroupPermissionSet.Get(OldUserGroupPermissionSet."User Group Code", NewPermissionSet, AggregatePermissionSet.Scope, AggregatePermissionSet."App ID") then CurrentUserGroupPermissionSet.Delete() else CurrentUserGroupPermissionSet.Rename(OldUserGroupPermissionSet."User Group Code", NewPermissionSet, AggregatePermissionSet.Scope, AggregatePermissionSet."App ID"); until OldUserGroupPermissionSet.Next() = 0; // User Group Access Control needs to be updated explicitly in v25+ OldUserGroupAccessControl.SetRange("Role ID", OldPermissionSet); if OldUserGroupAccessControl.FindSet() then repeat CurrentUserGroupAccessControl.Get(OldUserGroupAccessControl.RecordId()); if NewUserGroupAccessControl.Get(OldUserGroupAccessControl."User Group Code", OldUserGroupAccessControl."User Security ID", NewPermissionSet, OldUserGroupAccessControl."Company Name", AggregatePermissionSet.Scope, AggregatePermissionSet."App ID") then CurrentUserGroupAccessControl.Delete() else CurrentUserGroupAccessControl.Rename(OldUserGroupAccessControl."User Group Code", OldUserGroupAccessControl."User Security ID", NewPermissionSet, OldUserGroupAccessControl."Company Name", AggregatePermissionSet.Scope, AggregatePermissionSet."App ID"); until OldUserGroupAccessControl.Next() = 0; // Change the Access Control entries that point to the old permission set to point to the new one OldAccessControl.SetRange("Role ID", OldPermissionSet); if OldAccessControl.FindSet() then repeat CurrentAccessControl.Get(OldAccessControl.RecordId()); if NewAccessControl.Get(OldAccessControl."User Security ID", NewPermissionSet, OldAccessControl."Company Name", AggregatePermissionSet.Scope, AggregatePermissionSet."App ID") then CurrentAccessControl.Delete() else CurrentAccessControl.Rename(OldAccessControl."User Security ID", NewPermissionSet, OldAccessControl."Company Name", AggregatePermissionSet.Scope, AggregatePermissionSet."App ID"); until OldAccessControl.Next() = 0; end; var NewPermissionSetNotFoundTxt: Label 'Skipping the upgrade of %1 to %2, as we could not find the permission set %2.', Locked = true; TelemetryCategoryTxt: Label 'AL SaaS upgrade', Locked = true;}