XmlPort 9864 Import Permission Sets
src/System Application/App/Permission Sets/src/xmlports/ImportPermissionSets.xmlport.al450 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 System.Security.AccessControl;using System.Security.User;/// <summary>/// Xmlport for importing permission sets./// </summary>xmlport 9864 "Import Permission Sets"{ Caption = 'Import Permission Sets'; Direction = Import; Encoding = UTF8; PreserveWhiteSpace = true; schema { textelement(PermissionSets) { textattribute(Version) { TextType = Text; Description = 'Version'; } tableelement(TempTenantPermissionSet; "Tenant Permission Set") { MinOccurs = Zero; XmlName = 'TenantPermissionSet'; SourceTableView = sorting("App ID", "Role ID"); UseTemporary = true; fieldattribute(AppID; TempTenantPermissionSet."App ID") { Occurrence = Optional; } fieldattribute(RoleID; TempTenantPermissionSet."Role ID") { } fieldattribute(RoleName; TempTenantPermissionSet.Name) { } fieldattribute(Assignable; TempTenantPermissionSet.Assignable) { } tableelement(TempTenantPermissionSetRel; "Tenant Permission Set Rel.") { LinkTable = TempTenantPermissionSet; LinkFields = "App ID" = field("App ID"), "Role ID" = field("Role ID"); MinOccurs = Zero; XmlName = 'TenantPermissionSetRel'; SourceTableView = sorting("App ID", "Role ID", "Related App ID", "Related Role ID"); UseTemporary = true; fieldelement(ObjectType; TempTenantPermissionSetRel.Type) { } fieldelement(ObjectRelatedScope; TempTenantPermissionSetRel."Related Scope") { } fieldelement(ObjectRelatedRoleId; TempTenantPermissionSetRel."Related Role ID") { } fieldelement(ObjectRelatedAppId; TempTenantPermissionSetRel."Related App ID") { } } tableelement(TempTenantPermission; "Tenant Permission") { LinkFields = "App ID" = field("App ID"), "Role ID" = field("Role ID"); LinkTable = TempTenantPermissionSet; MinOccurs = Zero; XmlName = 'TenantPermission'; SourceTableView = sorting("Role ID", "Object Type", "Object ID"); UseTemporary = true; fieldelement(ObjectType; TempTenantPermission."Object Type") { } fieldelement(ObjectID; TempTenantPermission."Object ID") { } fieldelement(ReadPermission; TempTenantPermission."Read Permission") { MinOccurs = Zero; } fieldelement(InsertPermission; TempTenantPermission."Insert Permission") { MinOccurs = Zero; } fieldelement(ModifyPermission; TempTenantPermission."Modify Permission") { MinOccurs = Zero; } fieldelement(DeletePermission; TempTenantPermission."Delete Permission") { MinOccurs = Zero; } fieldelement(ExecutePermission; TempTenantPermission."Execute Permission") { MinOccurs = Zero; } fieldelement(SecurityFilter; TempTenantPermission."Security Filter") { MinOccurs = Zero; } fieldelement(PermissionType; TempTenantPermission.Type) { MinOccurs = Zero; } trigger OnAfterInitRecord() begin TempTenantPermission."Read Permission" := TempTenantPermission."Read Permission"::" "; TempTenantPermission."Insert Permission" := TempTenantPermission."Insert Permission"::" "; TempTenantPermission."Modify Permission" := TempTenantPermission."Modify Permission"::" "; TempTenantPermission."Delete Permission" := TempTenantPermission."Delete Permission"::" "; TempTenantPermission."Execute Permission" := TempTenantPermission."Execute Permission"::" "; end; } trigger OnBeforeInsertRecord() var TenantPermission: Record "Tenant Permission"; TenantPermissionSetRel: Record "Tenant Permission Set Rel."; begin if TempTenantPermissionSet.Get(TempTenantPermissionSet."App ID", TempTenantPermissionSet."Role ID") then currXMLport.Skip(); if not UpdatePermissions then begin TenantPermissionSetRel.SetRange("App ID", TempTenantPermissionSet."App ID"); TenantPermissionSetRel.SetRange("Role ID", TempTenantPermissionSet."Role ID"); TenantPermissionSetRel.DeleteAll(); TenantPermission.SetRange("App ID", TempTenantPermissionSet."App ID"); TenantPermission.SetRange("Role ID", TempTenantPermissionSet."Role ID"); TenantPermission.DeleteAll(); end; end; } tableelement(TempMetadataPermissionSet; "Metadata Permission Set") { MinOccurs = Zero; XmlName = 'PermissionSet'; UseTemporary = true; fieldattribute(AppID; TempMetadataPermissionSet."App ID") { Occurrence = Optional; } fieldattribute(RoleID; TempMetadataPermissionSet."Role ID") { } fieldattribute(RoleName; TempMetadataPermissionSet.Name) { } fieldattribute(Assignable; TempMetadataPermissionSet.Assignable) { } tableelement(TempMetadataPermissionSetRel; "Metadata Permission Set Rel.") { LinkTable = TempMetadataPermissionSet; LinkFields = "App ID" = field("App ID"), "Role ID" = field("Role ID"); MinOccurs = Zero; XmlName = 'PermissionSetRel'; SourceTableView = sorting("App ID", "Role ID", "Related App ID", "Related Role ID"); UseTemporary = true; fieldelement(ObjectType; TempMetadataPermissionSetRel.Type) { } fieldelement(ObjectRelatedRoleId; TempMetadataPermissionSetRel."Related Role ID") { } fieldelement(ObjectRelatedAppId; TempMetadataPermissionSetRel."Related App ID") { } } tableelement(TempMetadataPermission; "Metadata Permission") { LinkFields = "App ID" = field("App ID"), "Role ID" = field("Role ID"); LinkTable = TempMetadataPermissionSet; MinOccurs = Zero; XmlName = 'Permission'; SourceTableView = sorting("Role ID", "Object Type", "Object ID"); UseTemporary = true; fieldelement(ObjectType; TempMetadataPermission."Object Type") { } fieldelement(ObjectID; TempMetadataPermission."Object ID") { } fieldelement(ReadPermission; TempMetadataPermission."Read Permission") { MinOccurs = Zero; } fieldelement(InsertPermission; TempMetadataPermission."Insert Permission") { MinOccurs = Zero; } fieldelement(ModifyPermission; TempMetadataPermission."Modify Permission") { MinOccurs = Zero; } fieldelement(DeletePermission; TempMetadataPermission."Delete Permission") { MinOccurs = Zero; } fieldelement(ExecutePermission; TempMetadataPermission."Execute Permission") { MinOccurs = Zero; } fieldelement(SecurityFilter; TempMetadataPermission."Security Filter") { MinOccurs = Zero; } trigger OnAfterInitRecord() begin TempMetadataPermission."Read Permission" := TempMetadataPermission."Read Permission"::" "; TempMetadataPermission."Insert Permission" := TempMetadataPermission."Insert Permission"::" "; TempMetadataPermission."Modify Permission" := TempMetadataPermission."Modify Permission"::" "; TempMetadataPermission."Delete Permission" := TempMetadataPermission."Delete Permission"::" "; TempMetadataPermission."Execute Permission" := TempMetadataPermission."Execute Permission"::" "; end; } trigger OnBeforeInsertRecord() var TenantPermission: Record "Tenant Permission"; TenantPermissionSetRel: Record "Tenant Permission Set Rel."; NullGuid: Guid; begin if TempMetadataPermissionSet.Get(TempMetadataPermissionSet."App ID", TempMetadataPermissionSet."Role ID") then currXMLport.Skip(); if not UpdatePermissions then begin // System permission sets are imported as tenant permission sets with an empty App ID TenantPermissionSetRel.SetRange("App ID", NullGuid); TenantPermissionSetRel.SetRange("Role ID", TempMetadataPermissionSet."Role ID"); TenantPermissionSetRel.DeleteAll(); TenantPermission.SetRange("App ID", NullGuid); TenantPermission.SetRange("Role ID", TempMetadataPermissionSet."Role ID"); TenantPermission.DeleteAll(); end; end; } } } requestpage { } var UpdatePermissions: Boolean; CannotManagePermissionsErr: Label 'Only users with the SUPER or the SECURITY permission set can create or edit permission sets.'; trigger OnPreXmlPort() begin DisallowEditingPermissionSetsForNonAdminUsers(); OnAfterOnPreXmlPort(UpdatePermissions); end; trigger OnPostXmlPort() begin if TempMetadataPermissionSet.FindSet() then repeat ProcessSystemPermissionSet(TempMetadataPermissionSet); until TempMetadataPermissionSet.Next() = 0; if TempTenantPermissionSet.FindSet() then repeat ProcessTenantPermissionSet(TempTenantPermissionSet); until TempTenantPermissionSet.Next() = 0; end; procedure SetUpdatePermissions(NewUpdatePermissions: Boolean) begin UpdatePermissions := NewUpdatePermissions; end; local procedure ProcessSystemPermissionSet(MetadataPermissionSet: Record "Metadata Permission Set") begin TempMetadataPermission.SetRange("App ID", MetadataPermissionSet."App ID"); TempMetadataPermission.SetRange("Role ID", MetadataPermissionSet."Role ID"); TempMetadataPermissionSetRel.SetRange("App ID", MetadataPermissionSet."App ID"); TempMetadataPermissionSetRel.SetRange("Role ID", MetadataPermissionSet."Role ID"); InsertSystemPermissionSet(MetadataPermissionSet); if TempMetadataPermissionSetRel.FindSet() then repeat InsertSystemPermissionSetRelation(TempMetadataPermissionSetRel); until TempMetadataPermissionSetRel.Next() = 0; if TempMetadataPermission.FindSet() then repeat InsertSystemPermission(TempMetadataPermission); until TempMetadataPermission.Next() = 0; end; local procedure InsertSystemPermissionSet(SourceMetadataPermissionSet: Record "Metadata Permission Set") var TenantPermissionSet: Record "Tenant Permission Set"; NullGuid: Guid; begin if TenantPermissionSet.Get(NullGuid, SourceMetadataPermissionSet."Role ID") then exit; TenantPermissionSet.Init(); TenantPermissionSet.TransferFields(SourceMetadataPermissionSet); TenantPermissionSet."App ID" := NullGuid; TenantPermissionSet.Insert(); end; local procedure InsertSystemPermissionSetRelation(SourceMetadataPermissionSetRel: Record "Metadata Permission Set Rel.") var TenantPermissionSetRel: Record "Tenant Permission Set Rel."; NullGuid: Guid; begin if TenantPermissionSetRel.Get(NullGuid, SourceMetadataPermissionSetRel."Role ID", SourceMetadataPermissionSetRel."Related App ID", SourceMetadataPermissionSetRel."Related Role ID") then exit; TenantPermissionSetRel.Init(); TenantPermissionSetRel.TransferFields(SourceMetadataPermissionSetRel); TenantPermissionSetRel."App ID" := NullGuid; TenantPermissionSetRel.Insert(); end; local procedure InsertSystemPermission(SourceMetadataPermission: Record "Metadata Permission") var TenantPermission: Record "Tenant Permission"; NullGuid: Guid; begin if not TenantPermission.Get(NullGuid, SourceMetadataPermission."Role ID", SourceMetadataPermission."Object Type", SourceMetadataPermission."Object ID") then begin TenantPermission.Init(); TenantPermission."App ID" := NullGuid; TenantPermission."Role ID" := CopyStr(SourceMetadataPermission."Role ID", 1, MaxStrLen(TenantPermission."Role ID")); TenantPermission."Object Type" := SourceMetadataPermission."Object Type"; TenantPermission."Object ID" := SourceMetadataPermission."Object ID"; TenantPermission."Read Permission" := SourceMetadataPermission."Read Permission"; TenantPermission."Insert Permission" := SourceMetadataPermission."Insert Permission"; TenantPermission."Modify Permission" := SourceMetadataPermission."Modify Permission"; TenantPermission."Delete Permission" := SourceMetadataPermission."Delete Permission"; TenantPermission."Execute Permission" := SourceMetadataPermission."Execute Permission"; TenantPermission."Security Filter" := SourceMetadataPermission."Security Filter"; TenantPermission.Type := SourceMetadataPermission.Type; TenantPermission.Insert(); end else begin if IsFirstPermissionHigherThanSecond(SourceMetadataPermission."Read Permission", TenantPermission."Read Permission") then TenantPermission."Read Permission" := SourceMetadataPermission."Read Permission"; if IsFirstPermissionHigherThanSecond(SourceMetadataPermission."Insert Permission", TenantPermission."Insert Permission") then TenantPermission."Insert Permission" := SourceMetadataPermission."Insert Permission"; if IsFirstPermissionHigherThanSecond(SourceMetadataPermission."Modify Permission", TenantPermission."Modify Permission") then TenantPermission."Modify Permission" := SourceMetadataPermission."Modify Permission"; if IsFirstPermissionHigherThanSecond(SourceMetadataPermission."Delete Permission", TenantPermission."Delete Permission") then TenantPermission."Delete Permission" := SourceMetadataPermission."Delete Permission"; if IsFirstPermissionHigherThanSecond(SourceMetadataPermission."Execute Permission", TenantPermission."Execute Permission") then TenantPermission."Execute Permission" := SourceMetadataPermission."Execute Permission"; TenantPermission."Security Filter" := SourceMetadataPermission."Security Filter"; TenantPermission.Modify(); end; end; local procedure ProcessTenantPermissionSet(TenantPermissionSet: Record "Tenant Permission Set") begin TempTenantPermission.SetRange("App ID", TenantPermissionSet."App ID"); TempTenantPermission.SetRange("Role ID", TenantPermissionSet."Role ID"); TempTenantPermissionSetRel.SetRange("App ID", TenantPermissionSet."App ID"); TempTenantPermissionSetRel.SetRange("Role ID", TenantPermissionSet."Role ID"); InsertTenantPermissionSet(TenantPermissionSet); if TempTenantPermissionSetRel.FindSet() then repeat InsertTenantPermissionSetRelation(TempTenantPermissionSetRel); until TempTenantPermissionSetRel.Next() = 0; if TempTenantPermission.FindSet() then repeat InsertTenantPermission(TempTenantPermission); until TempTenantPermission.Next() = 0; end; local procedure InsertTenantPermissionSetRelation(SourceTenantPermissionSetRel: Record "Tenant Permission Set Rel.") var TenantPermissionSetRel: Record "Tenant Permission Set Rel."; begin if TenantPermissionSetRel.Get(SourceTenantPermissionSetRel."App ID", SourceTenantPermissionSetRel."Role ID", SourceTenantPermissionSetRel."Related App ID", SourceTenantPermissionSetRel."Related Role ID") then exit; TenantPermissionSetRel.Init(); TenantPermissionSetRel.TransferFields(SourceTenantPermissionSetRel); TenantPermissionSetRel.Insert(); end; local procedure InsertTenantPermissionSet(SourceTenantPermissionSet: Record "Tenant Permission Set") var TenantPermissionSet: Record "Tenant Permission Set"; begin if TenantPermissionSet.Get(SourceTenantPermissionSet."App ID", SourceTenantPermissionSet."Role ID") then exit; TenantPermissionSet.Init(); TenantPermissionSet.TransferFields(SourceTenantPermissionSet); TenantPermissionSet.Assignable := true; TenantPermissionSet.Insert(); end; local procedure InsertTenantPermission(SourceTenantPermission: Record "Tenant Permission") var TenantPermission: Record "Tenant Permission"; begin if not TenantPermission.Get(SourceTenantPermission."App ID", SourceTenantPermission."Role ID", SourceTenantPermission."Object Type", SourceTenantPermission."Object ID") then begin TenantPermission.Init(); TenantPermission.TransferFields(SourceTenantPermission); TenantPermission.Insert(); end else begin if IsFirstPermissionHigherThanSecond(SourceTenantPermission."Read Permission", TenantPermission."Read Permission") then TenantPermission."Read Permission" := SourceTenantPermission."Read Permission"; if IsFirstPermissionHigherThanSecond(SourceTenantPermission."Insert Permission", TenantPermission."Insert Permission") then TenantPermission."Insert Permission" := SourceTenantPermission."Insert Permission"; if IsFirstPermissionHigherThanSecond(SourceTenantPermission."Modify Permission", TenantPermission."Modify Permission") then TenantPermission."Modify Permission" := SourceTenantPermission."Modify Permission"; if IsFirstPermissionHigherThanSecond(SourceTenantPermission."Delete Permission", TenantPermission."Delete Permission") then TenantPermission."Delete Permission" := SourceTenantPermission."Delete Permission"; if IsFirstPermissionHigherThanSecond(SourceTenantPermission."Execute Permission", TenantPermission."Execute Permission") then TenantPermission."Execute Permission" := SourceTenantPermission."Execute Permission"; TenantPermission."Security Filter" := SourceTenantPermission."Security Filter"; TenantPermission.Modify(); end; end; local procedure IsFirstPermissionHigherThanSecond(First: Option; Second: Option): Boolean var ExpandedPermission: Record "Expanded Permission"; begin case First of ExpandedPermission."Read Permission"::" ": exit(false); ExpandedPermission."Read Permission"::Indirect: exit(Second = ExpandedPermission."Read Permission"::" "); ExpandedPermission."Read Permission"::Yes: exit(Second in [ExpandedPermission."Read Permission"::Indirect, ExpandedPermission."Read Permission"::" "]); end; end; local procedure DisallowEditingPermissionSetsForNonAdminUsers() var UserPermissions: Codeunit "User Permissions"; begin if not UserPermissions.CanManageUsersOnTenant(UserSecurityId()) then Error(CannotManagePermissionsErr); end; [IntegrationEvent(false, false)] local procedure OnAfterOnPreXmlPort(var UpdatePermissions: Boolean) begin end;}