Table 9018 Custom Permission Set In Plan
src/System Application/App/Azure AD Plan/src/Plan Configuration/Custom Permissions/CustomPermissionSetInPlan.Table.al110 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.Azure.Identity;using System.Apps;using System.Environment;using System.Security.AccessControl;table 9018 "Custom Permission Set In Plan"{ Caption = 'Custom Permissions In License'; Access = Internal; InherentEntitlements = rX; InherentPermissions = rX; Extensible = false; DataPerCompany = false; ReplicateData = false; fields { field(1; Id; Integer) { DataClassification = SystemMetadata; AutoIncrement = true; } field(2; "Plan ID"; Guid) { DataClassification = SystemMetadata; Caption = 'Plan ID'; TableRelation = Plan."Plan ID"; } field(3; "Role ID"; Code[20]) { DataClassification = CustomerContent; Caption = 'Permission Set'; TableRelation = "Aggregate Permission Set"."Role ID"; } field(4; "Role Name"; Text[30]) { CalcFormula = lookup("Aggregate Permission Set".Name where("Role ID" = field("Role ID"))); Caption = 'Name'; Editable = false; FieldClass = FlowField; } field(5; "App ID"; Guid) { DataClassification = SystemMetadata; Caption = 'App ID'; } field(6; "App Name"; Text[250]) { CalcFormula = lookup("Published Application".Name where(ID = field("App ID"), "Tenant Visible" = const(true))); Caption = 'Extension Name'; Editable = false; FieldClass = FlowField; } field(7; Scope; Option) { DataClassification = SystemMetadata; Caption = 'Scope'; OptionCaption = 'System,Tenant'; OptionMembers = System,Tenant; } field(8; "Company Name"; Text[30]) { DataClassification = SystemMetadata; Caption = 'Company Name'; TableRelation = Company; } } keys { key(PrimaryKey; Id) { Clustered = true; } key(UniqueKey; "Plan ID", "Role ID", "Company Name", Scope, "App ID") { Unique = true; } } trigger OnInsert() begin PlanConfiguration.VerifyUserHasRequiredPermissionSet(Rec."Role ID", Rec."App ID", Rec.Scope, Rec."Company Name"); end; trigger OnDelete() begin PlanConfiguration.VerifyUserHasRequiredPermissionSet(Rec."Role ID", Rec."App ID", Rec.Scope, Rec."Company Name"); end; trigger OnModify() begin PlanConfiguration.VerifyUserHasRequiredPermissionSet(Rec."Role ID", Rec."App ID", Rec.Scope, Rec."Company Name"); end; trigger OnRename() begin PlanConfiguration.VerifyUserHasRequiredPermissionSet(Rec."Role ID", Rec."App ID", Rec.Scope, Rec."Company Name"); end; var PlanConfiguration: Codeunit "Plan Configuration";}