Codeunit 9852 Effective Permissions Mgt.
src/Layers/W1/BaseApp/System/Permissions/EffectivePermissionsMgt.Codeunit.al924 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Security.AccessControl;using System;using System.Azure.Identity;using System.Environment;using System.Environment.Configuration;using System.IO;using System.Reflection;using System.Security.User;codeunit 9852 "Effective Permissions Mgt."{ trigger OnRun() begin end; var UserAccountHelper: DotNet NavUserAccountHelper; AccessControlFilterForUserCache: Dictionary of [Guid, Text]; DialogFormatMsg: Label 'Reading objects...@1@@@@@@@@@@@@@@@@@@'; CannotViewEffectivePermissionsForOtherUserErr: Label 'Only users with the SUPER or the SECURITY permission set can view effective permissions for other users.'; ChangeAffectsOthersMsg: Label 'Your change in permission set %1 will affect other users that the permission set is assigned to.', Comment = '%1 = permission set ID that was changed'; ChangeAffectsOthersNameTxt: Label 'Changing permission sets for other users'; ChangeAffectsOthersDescTxt: Label 'Show a warning when changing a permission set that is assigned to other users.'; DirectConflictWithIndirectMsg: Label 'This user has been given the Yes permission for the selected object, but their license allows them only the Indirect permission.'; DirectConflictWithNoneMsg: Label 'This user has been given the Yes permission to the selected object, but the object is not included in their license.'; IndirectConflictWithNoneMsg: Label 'This user has been given the Indirect permission for the selected object, but the object is not included in their license.'; UserListLbl: Label 'See users affected'; UndoChangeLbl: Label 'Undo change'; DontShowAgainLbl: Label 'Never show again'; RevertChangeQst: Label 'Do you want to revert the recent change to permission set %1?', Comment = '%1 = the permission set ID that has been changed.'; ConflictLbl: Label '%1 (reduced)', Comment = '%1 = permission set type, e.g. Indirect'; procedure OpenPageForUser(UserSID: Guid) var EffectivePermissions: Page "Effective Permissions"; begin EffectivePermissions.SetUserSID(UserSID); EffectivePermissions.Run(); end; procedure DisallowViewingEffectivePermissionsForNonAdminUsers(OtherUserSecurityId: Guid) var UserPermissions: Codeunit "User Permissions"; begin if not UserPermissions.CanManageUsersOnTenant(UserSecurityId()) then if OtherUserSecurityId <> UserSecurityId() then Error(CannotViewEffectivePermissionsForOtherUserErr); end; local procedure GetPlanId(PlanOrRole: Enum Licenses): guid var PlanIds: Codeunit "Plan Ids"; begin case PlanOrRole of Enum::Licenses::Basic: exit(PlanIds.GetBasicPlanId()); Enum::Licenses::"Delegated Admin": exit(PlanIDs.GetDelegatedAdminPlanId()); Enum::Licenses::Device: exit(PlanIds.GetDevicePlanId()); Enum::Licenses::Essential: exit(PlanIds.GetEssentialPlanId()); Enum::Licenses::"External Accountant": exit(PlanIds.GetExternalAccountantPlanId()); Enum::Licenses::HelpDesk: exit(PlanIds.GetHelpDeskPlanId()); Enum::Licenses::"Internal Admin": exit(PlanIds.GetGlobalAdminPlanId()); Enum::Licenses::"D365 Admin": exit(PlanIds.GetD365AdminPlanId()); Enum::Licenses::Premium: exit(PlanIds.GetPremiumPlanId()); Enum::Licenses::"Team Member": exit(PlanIds.GetTeamMemberPlanId()); Enum::Licenses::Viral: exit(PlanIds.GetViralSignupPlanId()); end; end; internal procedure PopulatePermissionConflictsTable(PlanOrRole: Enum Licenses; RoleId: Code[20]; var PermissionConflicts: Record "Permission Conflicts" temporary) var ExpandedPermission: Record "Expanded Permission"; EntitlementPermissionsCommaStr: Text; Read: Integer; Insert: Integer; Modify: Integer; Delete: Integer; Execute: Integer; begin PermissionConflicts.Reset(); PermissionConflicts.DeleteAll(); ExpandedPermission.SetRange("Role ID", RoleId); ExpandedPermission.SetRange("Object Type", ExpandedPermission."Object Type"::"Table Data"); if ExpandedPermission.FindSet() then repeat EntitlementPermissionsCommaStr := UserAccountHelper.GetEntitlementPermissionForObjectAndPlan(GetPlanId(PlanOrRole), ExpandedPermission."Object Type"::"Table Data", ExpandedPermission."Object ID"); ExtractPermissionsFromText(EntitlementPermissionsCommaStr, Read, Insert, Modify, Delete, Execute); InitializePermissionConflicts(ExpandedPermission."Object Type", ExpandedPermission."Object ID", ExpandedPermission."Read Permission", ExpandedPermission."Insert Permission", ExpandedPermission."Modify Permission", ExpandedPermission."Delete Permission", ExpandedPermission."Execute Permission", ExpandedPermission.Scope = ExpandedPermission.Scope::System, PermissionConflicts); UpdatePermissionIfHigherPermission(Read, PermissionConflicts."Entitlement Read Permission"); UpdatePermissionIfHigherPermission(Insert, PermissionConflicts."Entitlement Insert Permission"); UpdatePermissionIfHigherPermission(Modify, PermissionConflicts."Entitlement Modify Permission"); UpdatePermissionIfHigherPermission(Delete, PermissionConflicts."Entitlement Delete Permission"); UpdatePermissionIfHigherPermission(Execute, PermissionConflicts."Entitlement Execute Permission"); InsertPermissionConflictIfConflictExists(PermissionConflicts); until ExpandedPermission.Next() = 0; end; local procedure InitializePermissionConflicts(PermissionObjectType: Option; PermissionObjectID: Integer; ReadPerm: Option; InsertPerm: Option; ModifyPerm: Option; DeletePerm: Option; ExecutePerm: Option; UserDefined: Boolean; var PermissionConflicts: Record "Permission Conflicts") begin PermissionConflicts.Init(); PermissionConflicts."Object Type" := PermissionObjectType; PermissionConflicts."Object ID" := PermissionObjectID; PermissionConflicts."Read Permission" := ConvertToPermission(ReadPerm); PermissionConflicts."Insert Permission" := ConvertToPermission(InsertPerm); PermissionConflicts."Modify Permission" := ConvertToPermission(ModifyPerm); PermissionConflicts."Delete Permission" := ConvertToPermission(DeletePerm); PermissionConflicts."Execute Permission" := ConvertToPermission(ExecutePerm); PermissionConflicts."Entitlement Read Permission" := PermissionConflicts."Entitlement Read Permission"::None; PermissionConflicts."Entitlement Insert Permission" := PermissionConflicts."Entitlement Read Permission"::None; PermissionConflicts."Entitlement Modify Permission" := PermissionConflicts."Entitlement Read Permission"::None; PermissionConflicts."Entitlement Delete Permission" := PermissionConflicts."Entitlement Read Permission"::None; PermissionConflicts."Entitlement Execute Permission" := PermissionConflicts."Entitlement Read Permission"::None; PermissionConflicts."User Defined" := UserDefined; end; local procedure UpdatePermissionIfHigherPermission(Permission: Option; var UpdatePermission: Enum Permission) var ConvertedPermission: Enum Permission; begin ConvertedPermission := ConvertToPermission(Permission); if ConvertedPermission.AsInteger() > UpdatePermission.AsInteger() then UpdatePermission := ConvertedPermission; end; local procedure InsertPermissionConflictIfConflictExists(var PermissionConflicts: Record "Permission Conflicts") var RIMDConflict: Boolean; ExecuteConflict: Boolean; begin if (PermissionConflicts."Read Permission".AsInteger() > PermissionConflicts."Entitlement Read Permission".AsInteger()) or (PermissionConflicts."Insert Permission".AsInteger() > PermissionConflicts."Entitlement Insert Permission".AsInteger()) or (PermissionConflicts."Modify Permission".AsInteger() > PermissionConflicts."Entitlement Modify Permission".AsInteger()) or (PermissionConflicts."Delete Permission".AsInteger() > PermissionConflicts."Entitlement Delete Permission".AsInteger()) then RIMDConflict := true; if (PermissionConflicts."Object Type" = PermissionConflicts."Object Type"::System) and (PermissionConflicts."Execute Permission".AsInteger() > PermissionConflicts."Entitlement Execute Permission".AsInteger()) then ExecuteConflict := true; if RIMDConflict or ExecuteConflict then PermissionConflicts.Insert(); end; internal procedure PopulatePermissionConflictsOverviewTable(var PermissionConflictsOverview: Record "Permission Conflicts Overview" temporary; PlansExist: Dictionary of [Guid, Boolean]) var MetadataPermissionSet: Record "Metadata Permission Set"; TenantPermissionSet: Record "Tenant Permission Set"; ProgressBar: Codeunit "Config. Progress Bar"; PlanIds: Codeunit "Plan Ids"; PlanOrRole: Enum Licenses; CurrentPermissionSet: Integer; TotalPermissionSets: Integer; ProgressBarTitleLbl: Label 'Loading permission sets'; ProgressLbl: Label '#1#### of #2####', Comment = '#1 - Current permission set, #2 - Total number of permission sets'; begin TotalPermissionSets := MetadataPermissionSet.Count() + TenantPermissionSet.Count(); ProgressBar.Init(TotalPermissionSets, 1, ProgressBarTitleLbl); PermissionConflictsOverview.Reset(); PermissionConflictsOverview.DeleteAll(); MetadataPermissionSet.SetRange(Assignable, true); if MetadataPermissionSet.FindSet() then repeat CurrentPermissionSet += 1; ProgressBar.Update(StrSubstNo(ProgressLbl, CurrentPermissionSet, TotalPermissionSets)); PermissionConflictsOverview.PermissionSetID := CopyStr(MetadataPermissionSet."Role ID", 1, 20); // Assignable permission sets are always limited to length 20 PermissionConflictsOverview.Type := PermissionConflictsOverview.Type::System; if PlansExist.ContainsKey(PlanIds.GetBasicPlanId()) then PermissionConflictsOverview.Basic := IsPermissionSetCoveredByLicense(PlanOrRole::Basic, MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetTeamMemberPlanId()) then PermissionConflictsOverview."Team Member" := IsPermissionSetCoveredByLicense(PlanOrRole::"Team Member", MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetEssentialPlanId()) then PermissionConflictsOverview.Essential := IsPermissionSetCoveredByLicense(PlanOrRole::Essential, MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetPremiumPlanId()) then PermissionConflictsOverview.Premium := IsPermissionSetCoveredByLicense(PlanOrRole::Premium, MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetDevicePlanId()) then PermissionConflictsOverview.Device := IsPermissionSetCoveredByLicense(PlanOrRole::Device, MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetExternalAccountantPlanId()) then PermissionConflictsOverview."External Accountant" := IsPermissionSetCoveredByLicense(PlanOrRole::"External Accountant", MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetGlobalAdminPlanId()) then PermissionConflictsOverview."Internal Admin" := IsPermissionSetCoveredByLicense(PlanOrRole::"Internal Admin", MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetD365AdminPlanId()) then PermissionConflictsOverview."D365 Admin" := IsPermissionSetCoveredByLicense(PlanOrRole::"D365 Admin", MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetDelegatedAdminPlanId()) then PermissionConflictsOverview."Delegated Admin" := IsPermissionSetCoveredByLicense(PlanOrRole::"Delegated Admin", MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetHelpDeskPlanId()) then PermissionConflictsOverview.HelpDesk := IsPermissionSetCoveredByLicense(PlanOrRole::HelpDesk, MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); if PlansExist.ContainsKey(PlanIds.GetViralSignupPlanId()) then PermissionConflictsOverview.Viral := IsPermissionSetCoveredByLicense(PlanOrRole::Viral, MetadataPermissionSet."Role ID", PermissionConflictsOverview.Type::System); PermissionConflictsOverview.Insert(); until MetadataPermissionSet.Next() = 0; if TenantPermissionSet.FindSet() then repeat CurrentPermissionSet += 1; ProgressBar.Update(StrSubstNo(ProgressLbl, CurrentPermissionSet, TotalPermissionSets)); PermissionConflictsOverview.PermissionSetID := TenantPermissionSet."Role ID"; PermissionConflictsOverview.Type := PermissionConflictsOverview.Type::User; if PlansExist.ContainsKey(PlanIds.GetBasicPlanId()) then PermissionConflictsOverview.Basic := IsPermissionSetCoveredByLicense(PlanOrRole::Basic, TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetTeamMemberPlanId()) then PermissionConflictsOverview."Team Member" := IsPermissionSetCoveredByLicense(PlanOrRole::"Team Member", TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetEssentialPlanId()) then PermissionConflictsOverview.Essential := IsPermissionSetCoveredByLicense(PlanOrRole::Essential, TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetPremiumPlanId()) then PermissionConflictsOverview.Premium := IsPermissionSetCoveredByLicense(PlanOrRole::Premium, TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetDevicePlanId()) then PermissionConflictsOverview.Device := IsPermissionSetCoveredByLicense(PlanOrRole::Device, TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetExternalAccountantPlanId()) then PermissionConflictsOverview."External Accountant" := IsPermissionSetCoveredByLicense(PlanOrRole::"External Accountant", TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetGlobalAdminPlanId()) then PermissionConflictsOverview."Internal Admin" := IsPermissionSetCoveredByLicense(PlanOrRole::"Internal Admin", TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetD365AdminPlanId()) then PermissionConflictsOverview."D365 Admin" := IsPermissionSetCoveredByLicense(PlanOrRole::"D365 Admin", TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetDelegatedAdminPlanId()) then PermissionConflictsOverview."Delegated Admin" := IsPermissionSetCoveredByLicense(PlanOrRole::"Delegated Admin", TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetHelpDeskPlanId()) then PermissionConflictsOverview.HelpDesk := IsPermissionSetCoveredByLicense(PlanOrRole::HelpDesk, TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); if PlansExist.ContainsKey(PlanIds.GetViralSignupPlanId()) then PermissionConflictsOverview.Viral := IsPermissionSetCoveredByLicense(PlanOrRole::Viral, TenantPermissionSet."Role ID", PermissionConflictsOverview.Type::User); PermissionConflictsOverview.Insert(); until TenantPermissionSet.Next() = 0; ProgressBar.Close(); end; local procedure IsPermissionSetCoveredByLicense(PlanOrRole: Enum Licenses; PermissionSetID: Code[30]; PermissionType: Option): Boolean var ExpandedPermission: Record "Expanded Permission"; PermissionConflictsOverview: Record "Permission Conflicts Overview"; PermissionBuffer: Record "Permission Buffer"; begin if PermissionType = PermissionConflictsOverview.Type::System then ExpandedPermission.SetRange(Scope, ExpandedPermission.Scope::System) else ExpandedPermission.SetRange(Scope, ExpandedPermission.Scope::Tenant); ExpandedPermission.SetRange("Role ID", PermissionSetID); ExpandedPermission.SetRange("Object Type", ExpandedPermission."Object Type"::"Table Data"); if ExpandedPermission.FindSet() then repeat FillPermissionBufferFromExpandedPermission(PermissionBuffer, ExpandedPermission); if IsPermissionRestrictedByLicense(PermissionBuffer, ExpandedPermission."Object Type", ExpandedPermission."Object ID", PlanOrRole) then exit(false); until ExpandedPermission.Next() = 0; exit(true); end; local procedure IsPermissionRestrictedByLicense(Permission: Record "Permission Buffer"; PermissionObjectType: Option; PermissionObjectId: Integer; PlanOrRole: Enum Licenses) Result: Boolean var DummyExpandedPermission: Record "Expanded Permission"; PermissionManager: Codeunit "Permission Manager"; EntitlementPermissionsCommaStr: Text; Read: Integer; Insert: Integer; Modify: Integer; Delete: Integer; Execute: Integer; begin EntitlementPermissionsCommaStr := UserAccountHelper.GetEntitlementPermissionForObjectAndPlan(GetPlanId(PlanOrRole), PermissionObjectType, PermissionObjectId); ExtractPermissionsFromText(EntitlementPermissionsCommaStr, Read, Insert, Modify, Delete, Execute); if PermissionObjectType = DummyExpandedPermission."Object Type"::"Table Data" then begin Result := PermissionManager.IsFirstPermissionHigherThanSecond(Permission."Read Permission", Read); Result := Result or PermissionManager.IsFirstPermissionHigherThanSecond(Permission."Insert Permission", Insert); Result := Result or PermissionManager.IsFirstPermissionHigherThanSecond(Permission."Modify Permission", Modify); Result := Result or PermissionManager.IsFirstPermissionHigherThanSecond(Permission."Delete Permission", Delete); end else Result := PermissionManager.IsFirstPermissionHigherThanSecond(Permission."Execute Permission", Execute); exit(Result); end; procedure PopulatePermissionBuffer(var PermissionBuffer: Record "Permission Buffer"; PassedUserID: Guid; PassedCompanyName: Text[50]; PassedObjectType: Integer; PassedObjectId: Integer) var AccessControl: Record "Access Control"; EffectivePermission: Record Permission; ExpandedPermission: Record "Expanded Permission"; PermissionSetBuffer: Record "Permission Set Buffer"; AssignedRead, AssignedInsert, AssignedModify, AssignedDelete, AssignedExecute : Integer; ExpandedPermissionFound: Boolean; PermissionBufferFilledFromSpecificPermission: Boolean; begin PermissionBuffer.Reset(); PermissionBuffer.DeleteAll(); ExpandedPermission.SetRange("Object Type", PassedObjectType); // find permissions from all permission sets for this user AccessControl.SetFilter("User Security ID", GetAccessControlFilterForUser(PassedUserID)); AccessControl.SetFilter("Company Name", '%1|%2', '', PassedCompanyName); if AccessControl.FindSet() then repeat // do not show permission sets for hidden extensions if StrPos(UpperCase(AccessControl."App Name"), UpperCase('_Exclude_')) <> 1 then begin PermissionBuffer.Init(); PermissionBuffer."Permission Set" := AccessControl."Role ID"; PermissionBuffer.Type := PermissionSetBuffer.GetType(AccessControl.Scope, AccessControl."App ID"); if AccessControl."User Security ID" = PassedUserID then PermissionBuffer.Source := PermissionBuffer.Source::Normal else PermissionBuffer.Source := PermissionBuffer.Source::"Security Group"; if AccessControl.Scope = AccessControl.Scope::System then ExpandedPermission.SetRange(Scope, ExpandedPermission.Scope::System) else ExpandedPermission.SetRange(Scope, ExpandedPermission.Scope::Tenant); ExpandedPermission.SetRange("App ID", AccessControl."App ID"); ExpandedPermission.SetRange("Role ID", AccessControl."Role ID"); // Specific object permissions override wildcard permissions, even when the wildcard has already // been expanded to the requested object in Expanded Permission. PermissionBufferFilledFromSpecificPermission := false; ExpandedPermissionFound := TryFillPermissionBufferFromSpecificPermission( PermissionBuffer, AccessControl, PassedObjectType, PassedObjectId); PermissionBufferFilledFromSpecificPermission := ExpandedPermissionFound; if not ExpandedPermissionFound then begin ExpandedPermission.SetRange("Object ID", PassedObjectId); ExpandedPermissionFound := ExpandedPermission.FindFirst(); end; if not ExpandedPermissionFound then begin ExpandedPermission.SetRange("Object ID", 0); ExpandedPermissionFound := ExpandedPermission.FindFirst(); end; if ExpandedPermissionFound then begin if not PermissionBufferFilledFromSpecificPermission then FillPermissionBufferFromExpandedPermission(PermissionBuffer, ExpandedPermission); SetHighestAssignedPermission(PermissionBuffer, AssignedRead, AssignedInsert, AssignedModify, AssignedDelete, AssignedExecute); PermissionBuffer.Order := PermissionBuffer.Source; if PermissionBuffer.Insert() then; // avoid errors in case the user was assigned same role both a specific company and globally end; end; until AccessControl.Next() = 0; // find inherent permissions PopulatePermissionRecordWithEffectivePermissionsForObject(EffectivePermission, PassedUserID, PassedCompanyName, PassedObjectType, PassedObjectId); PopulatePermissionBufferWithInherentPermission(AssignedRead, AssignedInsert, AssignedModify, AssignedDelete, AssignedExecute, EffectivePermission, PermissionBuffer); // find entitlement permission PopulatePermissionBufferWithEntitlementPermissionsForObject(PermissionBuffer, PassedUserID, PassedObjectType, PassedObjectId); end; procedure PopulatePermissionBufferWithEntitlementPermissionsForObject(var PermissionBuffer: Record "Permission Buffer"; PassedUserID: Guid; PassedObjectType: Option; PassedObjectId: Integer) var EnvironmentInfo: Codeunit "Environment Information"; PermissionCommaStr: Text; Read, Insert, Modify, Delete, Execute : Integer; begin if not EnvironmentInfo.IsSaaS() then exit; PermissionBuffer.Init(); PermissionBuffer.Source := PermissionBuffer.Source::Entitlement; PermissionBuffer."Permission Set" := ''; PermissionBuffer.Type := PermissionBuffer.Type::System; PermissionCommaStr := UserAccountHelper.GetEntitlementPermissionForObject(PassedUserID, PassedObjectType, PassedObjectId); ExtractPermissionsFromText(PermissionCommaStr, Read, Insert, Modify, Delete, Execute); PermissionBuffer."Read Permission" := Read; PermissionBuffer."Insert Permission" := Insert; PermissionBuffer."Modify Permission" := Modify; PermissionBuffer."Delete Permission" := Delete; PermissionBuffer."Execute Permission" := Execute; PermissionBuffer.Order := 10000; // order entitlement last PermissionBuffer.Insert(); end; local procedure PopulatePermissionBufferWithInherentPermission(AssignedRead: Integer; AssignedInsert: Integer; AssignedModify: Integer; AssignedDelete: Integer; AssignedExecute: Integer; var EffectivePermission: Record Permission; var PermissionBuffer: Record "Permission Buffer") begin if (EffectivePermission."Read Permission" > AssignedRead) or (EffectivePermission."Insert Permission" > AssignedInsert) or (EffectivePermission."Modify Permission" > AssignedModify) or (EffectivePermission."Delete Permission" > AssignedDelete) or (EffectivePermission."Execute Permission" > AssignedExecute) then begin PermissionBuffer.Init(); PermissionBuffer.Source := PermissionBuffer.Source::Inherent; PermissionBuffer."Permission Set" := '_'; PermissionBuffer.Type := PermissionBuffer.Type::System; PermissionBuffer.Order := PermissionBuffer.Source; if EffectivePermission."Read Permission" > AssignedRead then PermissionBuffer."Read Permission" := EffectivePermission."Read Permission" else PermissionBuffer."Read Permission" := EffectivePermission."Read Permission"::" "; if EffectivePermission."Insert Permission" > AssignedInsert then PermissionBuffer."Insert Permission" := EffectivePermission."Insert Permission" else PermissionBuffer."Insert Permission" := EffectivePermission."Insert Permission"::" "; if EffectivePermission."Modify Permission" > AssignedModify then PermissionBuffer."Modify Permission" := EffectivePermission."Modify Permission" else PermissionBuffer."Modify Permission" := EffectivePermission."Modify Permission"::" "; if EffectivePermission."Delete Permission" > AssignedDelete then PermissionBuffer."Delete Permission" := EffectivePermission."Delete Permission" else PermissionBuffer."Delete Permission" := EffectivePermission."Delete Permission"::" "; if EffectivePermission."Execute Permission" > AssignedExecute then PermissionBuffer."Execute Permission" := EffectivePermission."Execute Permission" else PermissionBuffer."Execute Permission" := EffectivePermission."Execute Permission"::" "; PermissionBuffer.Insert(); end; end; local procedure SetHighestAssignedPermission(PermissionBuffer: Record "Permission Buffer"; var AssignedRead: Integer; var AssignedInsert: Integer; var AssignedModify: Integer; var AssignedDelete: Integer; var AssignedExecute: Integer) begin if PermissionBuffer."Read Permission" > AssignedRead then AssignedRead := PermissionBuffer."Read Permission"; if PermissionBuffer."Insert Permission" > AssignedInsert then AssignedInsert := PermissionBuffer."Insert Permission"; if PermissionBuffer."Modify Permission" > AssignedModify then AssignedModify := PermissionBuffer."Modify Permission"; if PermissionBuffer."Delete Permission" > AssignedDelete then AssignedDelete := PermissionBuffer."Delete Permission"; if PermissionBuffer."Execute Permission" > AssignedExecute then AssignedExecute := PermissionBuffer."Execute Permission"; end; local procedure GetAccessControlFilterForUser(UserSecId: Guid): Text var SecurityGroupMemberBuffer: Record "Security Group Member Buffer"; SecurityGroup: Codeunit "Security Group"; FilterTextBuilder: TextBuilder; begin // Resolving security group membership is expensive (calls to Microsoft Entra for every group), so cache the result per user. if AccessControlFilterForUserCache.ContainsKey(UserSecId) then exit(AccessControlFilterForUserCache.Get(UserSecId)); // Consider permissions assigned to the user directly. FilterTextBuilder.Append(UserSecId); // Consider permissions assigned to the user through security groups. SecurityGroup.GetMembers(SecurityGroupMemberBuffer); SecurityGroupMemberBuffer.SetRange("User Security ID", UserSecId); if SecurityGroupMemberBuffer.FindSet() then repeat FilterTextBuilder.Append('|'); FilterTextBuilder.Append(SecurityGroup.GetGroupUserSecurityId(SecurityGroupMemberBuffer."Security Group Code")); until SecurityGroupMemberBuffer.Next() = 0; AccessControlFilterForUserCache.Set(UserSecId, FilterTextBuilder.ToText()); exit(FilterTextBuilder.ToText()); end; procedure PopulateEffectivePermissionsBuffer(var Permission: Record Permission; PassedUserID: Guid; PassedCompanyName: Text[50]; PassedObjectType: Integer; PassedObjectId: Integer; ShowAllObjects: Boolean) var AllObj: Record AllObj; Window: Dialog; TotalCount: Integer; NumObjectsProcessed: Integer; TimesToUpdate: Integer; begin Permission.Reset(); Permission.DeleteAll(); if PassedObjectId = 0 then begin Window.Open(DialogFormatMsg); AllObj.SetFilter("Object Type", '%1|%2|%3|%4|%5|%6|%7|%8|%9', Permission."Object Type"::"Table Data", Permission."Object Type"::Table, Permission."Object Type"::Report, Permission."Object Type"::Codeunit, Permission."Object Type"::XMLport, Permission."Object Type"::MenuSuite, Permission."Object Type"::Page, Permission."Object Type"::Query, Permission."Object Type"::System); if not ShowAllObjects then FilterOnlyObjectsPresentInUserPermissionSets(AllObj, PassedUserID, PassedCompanyName); if AllObj.FindSet() then begin TotalCount := AllObj.Count(); // Only update every 10 % TimesToUpdate := TotalCount div 10; if TimesToUpdate = 0 then TimesToUpdate := 1; repeat InsertEffectivePermissionForObject(Permission, PassedUserID, PassedCompanyName, AllObj."Object Type", AllObj."Object ID"); NumObjectsProcessed += 1; if (NumObjectsProcessed mod TimesToUpdate) = 0 then Window.Update(1, Round(NumObjectsProcessed * 10000 / TotalCount, 1)); until AllObj.Next() = 0; Permission.FindFirst(); end; Window.Close(); end else InsertEffectivePermissionForObject(Permission, PassedUserID, PassedCompanyName, PassedObjectType, PassedObjectId); end; local procedure FilterOnlyObjectsPresentInUserPermissionSets(var AllObj: Record AllObj; PassedUserID: Guid; PassedCompanyName: Text[50]) var AccessControl: Record "Access Control"; begin AccessControl.SetFilter("User Security ID", GetAccessControlFilterForUser(PassedUserID)); AccessControl.SetFilter("Company Name", '%1|%2', '', PassedCompanyName); if AccessControl.FindSet() then repeat MarkAllObjFromPermissionSet(AllObj, AccessControl."Role ID", AccessControl."App ID", AccessControl.Scope); until AccessControl.Next() = 0; AllObj.MarkedOnly(true); end; local procedure InsertEffectivePermissionForObject(var Permission: Record Permission; PassedUserID: Guid; PassedCompanyName: Text[50]; PassedObjectType: Integer; PassedObjectId: Integer) begin Permission.Init(); Permission."Object Type" := PassedObjectType; Permission."Object ID" := PassedObjectId; PopulatePermissionRecordWithEffectivePermissionsForObject(Permission, PassedUserID, PassedCompanyName, PassedObjectType, PassedObjectId); Permission.Insert(); end; local procedure FillPermissionBufferFromExpandedPermission(var PermissionBuffer: Record "Permission Buffer"; ExpandedPermission: Record "Expanded Permission") begin PermissionBuffer."Read Permission" := ExpandedPermission."Read Permission"; PermissionBuffer."Insert Permission" := ExpandedPermission."Insert Permission"; PermissionBuffer."Modify Permission" := ExpandedPermission."Modify Permission"; PermissionBuffer."Delete Permission" := ExpandedPermission."Delete Permission"; PermissionBuffer."Execute Permission" := ExpandedPermission."Execute Permission"; PermissionBuffer."Security Filter" := ExpandedPermission."Security Filter"; end; local procedure TryFillPermissionBufferFromSpecificPermission(var PermissionBuffer: Record "Permission Buffer"; AccessControl: Record "Access Control"; ObjectType: Integer; ObjectID: Integer): Boolean var MetadataPermission: Record "Metadata Permission"; TenantPermission: Record "Tenant Permission"; begin // Explicit blank permission lines (exclusions) are not stored in Expanded Permission, so read the source // permission line directly to detect a specific exclusion that must override the wildcard entry. if AccessControl.Scope = AccessControl.Scope::System then begin if MetadataPermission.Get(AccessControl."App ID", AccessControl."Role ID", ObjectType, ObjectID) then begin FillPermissionBufferFromMetadataPermission(PermissionBuffer, MetadataPermission); exit(true); end; exit(false); end; if TenantPermission.Get(AccessControl."App ID", AccessControl."Role ID", ObjectType, ObjectID) then begin FillPermissionBufferFromTenantPermission(PermissionBuffer, TenantPermission); exit(true); end; exit(false); end; local procedure FillPermissionBufferFromMetadataPermission(var PermissionBuffer: Record "Permission Buffer"; MetadataPermission: Record "Metadata Permission") begin PermissionBuffer."Read Permission" := MetadataPermission."Read Permission"; PermissionBuffer."Insert Permission" := MetadataPermission."Insert Permission"; PermissionBuffer."Modify Permission" := MetadataPermission."Modify Permission"; PermissionBuffer."Delete Permission" := MetadataPermission."Delete Permission"; PermissionBuffer."Execute Permission" := MetadataPermission."Execute Permission"; PermissionBuffer."Security Filter" := MetadataPermission."Security Filter"; end; local procedure FillPermissionBufferFromTenantPermission(var PermissionBuffer: Record "Permission Buffer"; TenantPermission: Record "Tenant Permission") begin PermissionBuffer."Read Permission" := TenantPermission."Read Permission"; PermissionBuffer."Insert Permission" := TenantPermission."Insert Permission"; PermissionBuffer."Modify Permission" := TenantPermission."Modify Permission"; PermissionBuffer."Delete Permission" := TenantPermission."Delete Permission"; PermissionBuffer."Execute Permission" := TenantPermission."Execute Permission"; PermissionBuffer."Security Filter" := TenantPermission."Security Filter"; end; local procedure MarkAllObjFromPermissionSet(var AllObj: Record AllObj; PermissionSetID: Code[20]; AppID: Guid; ObjScope: Option) var ExpandedPermission: Record "Expanded Permission"; begin ExpandedPermission.SetRange("App ID", AppID); ExpandedPermission.SetRange("Role ID", PermissionSetID); ExpandedPermission.SetRange(Scope, ObjScope); if ExpandedPermission.FindSet() then repeat MarkAllObj(AllObj, ExpandedPermission."Object Type", ExpandedPermission."Object ID"); until ExpandedPermission.Next() = 0; end; local procedure MarkAllObj(var AllObj: Record AllObj; ObjectTypePassed: Integer; ObjectIDPassed: Integer) begin if ObjectIDPassed = 0 then begin AllObj.SetRange("Object Type", ObjectTypePassed); if AllObj.FindSet() then repeat AllObj.Mark(true); until AllObj.Next() = 0; AllObj.SetRange("Object Type"); exit; end; if AllObj.Get(ObjectTypePassed, ObjectIDPassed) then AllObj.Mark(true); end; procedure PopulatePermissionRecordWithEffectivePermissionsForObject(var Permission: Record Permission; PassedUserID: Guid; PassedCompanyName: Text[50]; PassedObjectType: Option; PassedObjectId: Integer) var PermissionCommaStr: Text; Read: Integer; Insert: Integer; Modify: Integer; Delete: Integer; Execute: Integer; begin PermissionCommaStr := UserAccountHelper.GetEffectivePermissionForObject( PassedUserID, PassedCompanyName, PassedObjectType, PassedObjectId); ExtractPermissionsFromText(PermissionCommaStr, Read, Insert, Modify, Delete, Execute); Permission."Read Permission" := Read; Permission."Insert Permission" := Insert; Permission."Modify Permission" := Modify; Permission."Delete Permission" := Delete; Permission."Execute Permission" := Execute; end; local procedure ExtractPermissionsFromText(PermissionCommaStr: Text; var Read: Integer; var Insert: Integer; var Modify: Integer; var Delete: Integer; var Execute: Integer) begin Evaluate(Read, SelectStr(1, PermissionCommaStr)); Evaluate(Insert, SelectStr(2, PermissionCommaStr)); Evaluate(Modify, SelectStr(3, PermissionCommaStr)); Evaluate(Delete, SelectStr(4, PermissionCommaStr)); Evaluate(Execute, SelectStr(5, PermissionCommaStr)); end; procedure ModifyPermission(FieldNumChanged: Integer; PermissionBuffer: Record "Permission Buffer"; PassedObjectType: Integer; PassedObjectId: Integer; PassedUserID: Guid) var TenantPermission: Record "Tenant Permission"; CallModify: Boolean; OldValue: Integer; begin TenantPermission.Get(PermissionBuffer.GetAppID(), PermissionBuffer."Permission Set", PassedObjectType, PassedObjectId); case FieldNumChanged of TenantPermission.FieldNo("Read Permission"): begin OldValue := TenantPermission."Read Permission"; CallModify := TenantPermission."Read Permission" <> PermissionBuffer."Read Permission"; TenantPermission."Read Permission" := PermissionBuffer."Read Permission"; end; TenantPermission.FieldNo("Insert Permission"): begin OldValue := TenantPermission."Insert Permission"; CallModify := TenantPermission."Insert Permission" <> PermissionBuffer."Insert Permission"; TenantPermission."Insert Permission" := PermissionBuffer."Insert Permission"; end; TenantPermission.FieldNo("Modify Permission"): begin OldValue := TenantPermission."Modify Permission"; CallModify := TenantPermission."Modify Permission" <> PermissionBuffer."Modify Permission"; TenantPermission."Modify Permission" := PermissionBuffer."Modify Permission"; end; TenantPermission.FieldNo("Delete Permission"): begin OldValue := TenantPermission."Delete Permission"; CallModify := TenantPermission."Delete Permission" <> PermissionBuffer."Delete Permission"; TenantPermission."Delete Permission" := PermissionBuffer."Delete Permission"; end; TenantPermission.FieldNo("Execute Permission"): begin OldValue := TenantPermission."Execute Permission"; CallModify := TenantPermission."Execute Permission" <> PermissionBuffer."Execute Permission"; TenantPermission."Execute Permission" := PermissionBuffer."Execute Permission"; end; end; if not CallModify then exit; TenantPermission.Modify(); SendNotification(PermissionBuffer."Permission Set", PassedObjectType, PassedObjectId, PassedUserID, FieldNumChanged, OldValue); OnTenantPermissionModified(TenantPermission."Role ID"); end; local procedure SendNotification(PermissionSetID: Code[20]; PassedObjectType: Integer; PassedObjectId: Integer; UserOnPage: Guid; FieldNumChanged: Integer; OldValue: Integer) var User: Record User; MyNotifications: Record "My Notifications"; Notification: Notification; NotificationID: Guid; begin MarkUsersWithAssignedPermissionSet(User, PermissionSetID); User.SetFilter("User Security ID", '<>%1', UserOnPage); if User.IsEmpty() then exit; NotificationID := GetPermissionChangeNotificationId(); if not MyNotifications.IsEnabled(NotificationID) then exit; Notification.Id := NotificationID; Notification.Message := StrSubstNo(ChangeAffectsOthersMsg, PermissionSetID); Notification.SetData('UserOnPage', UserOnPage); Notification.SetData('PermissionSetID', PermissionSetID); Notification.SetData('ObjectType', Format(PassedObjectType)); Notification.SetData('ObjectID', Format(PassedObjectId)); Notification.SetData('FieldNumChanged', Format(FieldNumChanged)); Notification.SetData('OldValue', Format(OldValue)); Notification.AddAction(UserListLbl, CODEUNIT::"Effective Permissions Mgt.", 'NotificationShowUsers'); Notification.AddAction(UndoChangeLbl, CODEUNIT::"Effective Permissions Mgt.", 'NotificationUndoChange'); Notification.AddAction(DontShowAgainLbl, CODEUNIT::"Effective Permissions Mgt.", 'DisableNotification'); Notification.Send(); end; procedure NotificationShowUsers(Notification: Notification) var User: Record User; PermissionSetID: Code[20]; begin PermissionSetID := CopyStr(Notification.GetData('PermissionSetID'), 1, 20); MarkUsersWithAssignedPermissionSet(User, PermissionSetID); User.SetFilter("User Security ID", '<>%1', Notification.GetData('UserOnPage')); PAGE.RunModal(PAGE::Users, User); if Confirm(StrSubstNo(RevertChangeQst, PermissionSetID), false) then NotificationUndoChange(Notification); end; procedure NotificationUndoChange(Notification: Notification) var TenantPermission: Record "Tenant Permission"; ZeroGUID: Guid; ObjType: Integer; ObjID: Integer; FieldNumChanged: Integer; OldValue: Integer; begin Evaluate(ObjType, Notification.GetData('ObjectType')); Evaluate(ObjID, Notification.GetData('ObjectID')); TenantPermission.Get(ZeroGUID, Notification.GetData('PermissionSetID'), ObjType, ObjID); Evaluate(FieldNumChanged, Notification.GetData('FieldNumChanged')); Evaluate(OldValue, Notification.GetData('OldValue')); case FieldNumChanged of TenantPermission.FieldNo("Read Permission"): TenantPermission."Read Permission" := OldValue; TenantPermission.FieldNo("Insert Permission"): TenantPermission."Insert Permission" := OldValue; TenantPermission.FieldNo("Modify Permission"): TenantPermission."Modify Permission" := OldValue; TenantPermission.FieldNo("Delete Permission"): TenantPermission."Delete Permission" := OldValue; TenantPermission.FieldNo("Execute Permission"): TenantPermission."Execute Permission" := OldValue; end; TenantPermission.Modify(); end; procedure DisableNotification(Notification: Notification) var MyNotifications: Record "My Notifications"; begin MyNotifications.Disable(GetPermissionChangeNotificationId()); end; procedure ConvertToPermission(PermissionOption: Option) Permission: enum Permission var PermissionBuffer: Record "Permission Buffer"; begin case PermissionOption of PermissionBuffer."Read Permission"::" ": exit(Permission::None); PermissionBuffer."Read Permission"::Yes: exit(Permission::Direct); PermissionBuffer."Read Permission"::Indirect: exit(Permission::Indirect); end; end; internal procedure ShowPermissionConflict(Permissions: Enum Permission; EntitlementPermissions: Enum Permission; IsSourceEntitlement: Boolean) var ConflictMsg: Text; begin if IsSourceEntitlement then exit; if not ArePermissionsInConflict(Permissions, EntitlementPermissions) then exit; if (Permissions = Permissions::Direct) and (EntitlementPermissions = EntitlementPermissions::Indirect) then ConflictMsg := DirectConflictWithIndirectMsg; if (Permissions = Permissions::Direct) and (EntitlementPermissions = EntitlementPermissions::None) then ConflictMsg := DirectConflictWithNoneMsg; if (Permissions = Permissions::Indirect) and (EntitlementPermissions = EntitlementPermissions::None) then ConflictMsg := IndirectConflictWithNoneMsg; Message(ConflictMsg); end; internal procedure GetPermissionStatus(Permissions: Enum Permission; EntitlementPermissions: Enum Permission; IsSourceEntitlement: Boolean): Text begin if IsSourceEntitlement then exit(Format(Permissions)); if not ArePermissionsInConflict(Permissions, EntitlementPermissions) then exit(Format(Permissions)); // Show the effective permission (the one that comes from the entitlement) and an indication that the permission has been reduced exit(StrSubstNo(ConflictLbl, Format(EntitlementPermissions))); end; local procedure ArePermissionsInConflict(PermissionsFromPermissionSet: Enum Permission; PermissionsFromEntitlement: Enum Permission): Boolean begin exit(PermissionsFromPermissionSet.AsInteger() > PermissionsFromEntitlement.AsInteger()); end; internal procedure OpenPermissionConflicts(PermissionSetID: Code[20]; PlanOrRole: Enum Licenses) var PermissionConflictsPage: Page "Permission Conflicts"; begin PermissionConflictsPage.SetPermissionSetId(PermissionSetID); PermissionConflictsPage.SetEntitlementId(PlanOrRole); PermissionConflictsPage.Run(); end; local procedure MarkUsersWithAssignedPermissionSet(var User: Record User; PermissionSetID: Code[20]) var AccessControl: Record "Access Control"; SecurityGroupBuffer: Record "Security Group Buffer"; SecurityGroupMemberBuffer: Record "Security Group Member Buffer"; SecurityGroup: Codeunit "Security Group"; GroupUserSecId: Guid; begin AccessControl.SetRange("Role ID", PermissionSetID); if AccessControl.FindSet() then repeat if User.Get(AccessControl."User Security ID") then User.Mark(true); until AccessControl.Next() = 0; SecurityGroup.GetGroups(SecurityGroupBuffer); SecurityGroup.GetMembers(SecurityGroupMemberBuffer); if SecurityGroupBuffer.FindSet() then repeat GroupUserSecId := SecurityGroup.GetGroupUserSecurityId(SecurityGroupBuffer.Code); AccessControl.SetRange("User Security ID", GroupUserSecId); AccessControl.SetRange("Role ID", PermissionSetID); // If the permission set is assigned to the security group if not AccessControl.IsEmpty() then begin // Mark all the security group members SecurityGroupMemberBuffer.SetRange("Security Group Code", SecurityGroupBuffer.Code); if SecurityGroupMemberBuffer.FindSet() then repeat if User.Get(SecurityGroupMemberBuffer."User Security ID") then User.Mark(true); until SecurityGroupMemberBuffer.Next() = 0; end; until SecurityGroupBuffer.Next() = 0; User.MarkedOnly(true); end; local procedure GetPermissionChangeNotificationId(): Guid begin exit('7E18A509-6579-471A-BF8D-4A9BDABB6008'); end; /// <summary> /// Checks if the user has direct read, insert and modify permissions on the given table id. /// </summary> /// <param name="TableId">Id of the table</param> /// <returns>True if user has direct read, insert and modify permissions on table.</returns> internal procedure HasDirectRIMPermissionsOnTableData(TableId: Integer): Boolean var MetadataPermission: Record "Metadata Permission"; EntitlementPermissionsCommaStr: Text; Read: Integer; Insert: Integer; Modify: Integer; Delete: Integer; Execute: Integer; begin EntitlementPermissionsCommaStr := UserAccountHelper.GetEntitlementPermissionForObject(UserSecurityId(), MetadataPermission."Object Type"::"Table Data", TableId); ExtractPermissionsFromText(EntitlementPermissionsCommaStr, Read, Insert, Modify, Delete, Execute); if ((Read = MetadataPermission."Read Permission"::Yes) and (Insert = MetadataPermission."Insert Permission"::Yes) and (Modify = MetadataPermission."Modify Permission"::Yes)) then exit(true); exit(false); end; [EventSubscriber(ObjectType::Page, Page::"My Notifications", 'OnInitializingNotificationWithDefaultState', '', false, false)] local procedure OnInitializingNotificationWithDefaultState() var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault(GetPermissionChangeNotificationId(), ChangeAffectsOthersNameTxt, ChangeAffectsOthersDescTxt, true); end; [IntegrationEvent(false, false)] local procedure OnTenantPermissionModified(PermissionSetId: Code[20]) begin end;}