Study guide

8.2 Table Permissions, Web Roles & Page Access Security

Microsoft Power Platform Functional Consultant PL-200

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Dataverse Tables, Relationships & Core Columns

1.1 Dataverse Table Types, Properties & Ownership 1.2 Table Relationships & Cascading Rules 1.3 Column Types, Formats, Primary Keys & Alternate Keys 1.4 Rollup, Calculated & Formula Columns with Power Fx

2 Chapter 2: Dataverse Data Management & Governance

2.1 Dataverse Search, Quick Find & Relevance Indexing 2.2 Auditing Configuration & Log Management 2.3 Duplicate Detection Rules & Settings 2.4 Bulk Record Operations, Data Import, Export & Templates

3 Chapter 3: Dataverse Security Model & Access Control

3.1 Business Units, Ownership Models & Modern BU Matrix 3.2 Security Roles, Privileges & Depth Levels 3.3 Teams Architecture: Owner, Access, and Microsoft Entra (AAD) Group Teams 3.4 Column-Level Security & Hierarchy Security Models

4 Chapter 4: Model-Driven App Fundamentals & Information Architecture

4.1 Model-Driven App Design, Site Map Navigation & Modern App Designer 4.2 Form Types: Main, Quick Create, Quick View & Card Forms 4.3 View Configuration, System Views, Personal Views & Filters

5 Chapter 5: Advanced Model-Driven App Components & Custom Pages

5.1 Custom Pages & Modern Commanding with Power Fx 5.2 Form Component Controls & Specialized UX Elements 5.3 Embedding Canvas Apps in Model-Driven Forms 5.4 Embedding Power BI Reports, Dashboards & Tiles

6 Chapter 6: Canvas Apps Structure, Formulas & Data Operations

6.1 Canvas App Architecture, Screens, Containers & Controls 6.2 Power Fx Formulas, Delegation & Data Source Limits 6.3 Variables (Context, Global), Collections & State Management 6.4 Triggering Power Automate Cloud Flows from Canvas Apps

7 Chapter 7: Power Pages Site Design, Navigation & Content

7.1 Power Pages Design Studio & Site Structure 7.2 Power Pages Templates, Styling & Responsive Layouts 7.3 Web Pages, Navigation Menus & Content Snippets

8 Chapter 8: Power Pages Data Integration, Forms & Web Roles

8.1 Power Pages Lists, Basic Forms & Advanced Forms 8.2 Table Permissions, Web Roles & Page Access Security 8.3 External Identity Providers & Authentication Configuration

9 Chapter 9: Power Automate Cloud Flow Fundamentals & Triggers

9.1 Cloud Flow Types: Automated, Instant, Scheduled & Desktop Overview 9.2 Dataverse Connector Triggers & Operational Filters 9.3 Standard Connectors, Custom Connectors & Connection References

10 Chapter 10: Cloud Flow Actions, Expressions & Logic Controls

10.1 Logic Controls: Conditions, Switches, Apply to Each & Do Until Loops 10.2 Variables, Data Operations & Dynamic Content Manipulation 10.3 Power Automate Expression Language (WDL / Functions) 10.4 Error Handling, Configure Run After & Scope Controls

11 Chapter 11: Business Process Flows & Guided Processes

11.1 Business Process Flow Architecture, Stages, Steps & Data Steps 11.2 Branching Rules & Multi-Entity Business Process Flows 11.3 BPF Action Steps, Workflows & Cloud Flow Execution 11.4 BPF Security Roles, Order & Process Lifecycle

12 Chapter 12: Classic Workflows, Business Rules & Modern Logic Extensibility

12.1 Classic Dataverse Workflows: Real-Time vs. Background (Async) 12.2 Business Rules: Scope & Actions 12.3 Low-Code Plug-ins in Dataverse: Automated vs. Instant 12.4 Troubleshooting Automations, Run History & Analytics

13 Chapter 13: Power Platform Environment Architecture & Security

13.1 Environment Types: Default, Sandbox, Production, Trial, Developer 13.2 Environment Governance, Groups, Routing & Capacity Management 13.3 Data Loss Prevention (DLP) Policies & Connector Classifications

14 Chapter 14: Application Lifecycle Management (ALM) & Solutions

14.1 Unmanaged vs. Managed Solutions & Solution Layering Mechanics 14.2 Solution Components, Dependencies, Publishers & Prefixes 14.3 Exporting, Importing, Upgrading & Patches 14.4 Solution Checker, App Checker & ALM Best Practices

15 Chapter 15: Enterprise Interoperability & Service Integration

15.1 Exchange / Server-Side Synchronization & Email Integration 15.2 SharePoint & OneDrive Document Management Integration 15.3 Microsoft Word & Excel Document Templates

16 Chapter 16: Copilot, AI Capabilities & Exam Strategy

16.1 Copilot Studio & Generative AI across Power Platform 16.2 AI Builder Prebuilt & Custom Models in Apps and Flows 16.3 PL-200 Exam Strategy, Time Management & Question Analysis

8.2 Table Permissions, Web Roles & Page Access Security

Key Takeaways Explain This Topic AI

Power Pages operates under a strict Zero Trust security model: all Dataverse data is completely inaccessible to portal users by default unless explicit Table Permissions are granted and mapped to Web Roles.

Table Permissions support four Access Types: Global (all records), Contact (direct 1:N or N:1 relationship to logged-in contact), Account (relationship to user's parent account), and Parent (inherited permissions from a parent table).

Table Permission privileges include Read, Write, Create, Delete, Append (associating another record to this one), and Append To (associating this record to another).

Web Roles categorize portal users: 'Authenticated Users' automatically applies to all logged-in users, 'Anonymous Users' applies to unauthenticated visitors, and Custom Web Roles provide role-specific access.

Web Page Access Rules control sitemap security using two right types: 'Restrict Read' (hides/blocks page and child pages from unauthorized users) and 'Grant Change' (authorizes front-end content editing).

Last updated: August 2026

Table Permissions, Web Roles & Page Access Security

Security is the foundational pillar of any external-facing web portal. When organizations expose Microsoft Dataverse entities to external users, they must guarantee that users can only view and manipulate the precise records they are authorized to access. Microsoft Power Pages implements a Zero Trust security architecture that completely isolates Dataverse data from the public web until explicit permissions and roles are established.

For the PL-200: Microsoft Power Platform Functional Consultant exam, you must master the configuration of Table Permissions (including all access types and privileges), child table permission hierarchies, Web Roles , and Web Page Access Rules .

1. The Power Pages Zero Trust Security Model

Unlike internal model-driven apps where Dataverse security roles govern access based on Business Units and User/Team ownership, Power Pages operates across an external web boundary where visitors are either anonymous or authenticated via external Identity Providers (such as Microsoft Entra ID or Google). +-----------------------------------------------------------------------------------+

  • | POWER PAGES 3-TIER SECURITY EVALUATION |
  • | |
  • | [1. WEB PAGE ACCESS RULES] ───> Can the user view/edit this Web Page / URL? |
  • | │ |
  • | ▼ (If Allowed) |
  • | [2. WEB ROLES] ───────────────> What personas does this Contact possess? |
  • | │ (Anonymous, Authenticated, Custom Web Roles) |
  • | ▼ |
  • | [3. TABLE PERMISSIONS] ───────> What Dataverse records & CRUD operations are |
  • | authorized for these Web Roles? |
  • | (Global, Contact, Account, Parent Scopes) |
  • +-----------------------------------------------------------------------------------+

Caution

Default Data Block: By default in Power Pages, all Dataverse tables have zero access for website visitors. If a consultant places a List or Basic Form on a web page without configuring valid Table Permissions and linking them to a Web Role, the List will render zero rows and the Form will return an "Access Denied" error.

2. Table Permission Access Types (Scopes)

A Table Permission defines the scope of records a portal user can interact with in a specific Dataverse table. Power Pages provides four distinct Access Types : +-----------------------------------------------------------------------------------+

  • | TABLE PERMISSION ACCESS TYPES |
  • | |
  • | [1. GLOBAL ACCESS] |
  • | └── Access to ALL records in the table regardless of relationship. |
  • | Best for: Public Product Catalogs, Knowledge Base, FAQ repositories. |
  • | |
  • | [2. CONTACT ACCESS] |
  • | └── Access scoped via 1:N or N:1 relationship to logged-in user's Contact. |
  • | Best for: User's own Support Tickets, Personal Profile, Orders. |
  • | |
  • | [3. ACCOUNT ACCESS] |
  • | └── Access scoped via relationship to the user's parent Account record. |
  • | Best for: B2B Portals, Company Invoices, Corporate Asset Management. |
  • | |
  • | [4. PARENT ACCESS] |
  • | └── Access inherited from a Parent Table Permission via schema relationship. |
  • | Best for: Child rows (e.g., Ticket Comments, Invoice Line Items). |
  • +-----------------------------------------------------------------------------------+
  • Access Types Comparison & Use Cases

Access Type Scope & Evaluation Mechanism Relationship Requirement Typical Business Scenario

Global Grants access to all records across the entire Dataverse table. None Public product catalogs, public job listings, global lookup tables, or portal administrator overrides.

Contact Grants access strictly to records that have a direct relationship to the authenticated user's contact record. Requires an existing 1:N , N:1 , or N:N relationship between the target table and the Contact table. B2C customer service portals where users manage their own personal profile, medical appointments, or submitted cases.

Account Grants access to records associated with the user's parent account (company/organization). Requires a relationship between the target table and Account , and the logged-in Contact must have their parentcustomerid set to that Account. B2B partner portals where employees at a distributor need to see all purchase orders, contracts, and service tickets filed by any colleague at their company.

Parent Inherits permissions dynamically from an existing Parent Table Permission . Requires a relationship between the child table and the parent table. Child records such as "Ticket Notes", "Order Lines", or "Project Milestone Tasks" inheriting security from the parent Case/Order/Project.

3. Table Permission Privileges

Within each Table Permission, consultants grant specific granular privileges that dictate allowable CRUD operations: +-----------------------------------------------------------------------------------+

  • | TABLE PERMISSION PRIVILEGE MATRIX |
  • | |
  • | [READ] ───> Query and display records in Lists and Forms |
  • | [WRITE] ───> Update existing record attributes on Edit Forms |
  • | [CREATE] ───> Insert new records on Insert Forms or Subgrid '+' buttons |
  • | [DELETE] ───> Remove records via List item actions or Subgrid buttons |
  • | [APPEND] ───> Associate OTHER records TO this record (Parent side) |
  • | [APPEND TO] ───> Associate THIS record TO another record (Child side) |
  • +-----------------------------------------------------------------------------------+
  • Understanding Append vs. Append To Mechanics

The distinction between Append and Append To is a core concept tested extensively on the PL-200 exam:

Append: Represents the right to attach or link another record into the current record. You configure Append on the record that is receiving the link.

Append To: Represents the right to link the current record to another target record. You configure Append To on the record that contains the lookup pointer.

Practical Relationship Example

Suppose a portal user is submitting a new Support Ticket Note (child record) linked to an existing Support Case (parent record):

On the Support Case table permission, the user must have Append (allowing other records to be attached to the Case).

On the Note / Ticket Comment table permission, the user must have Create and Append To (allowing the new Note to be linked to a Case).

Important

If the user has Create on Notes but lacks Append To on Notes, or lacks Append on the parent Case, the record creation will fail with a relationship authorization exception.

4. Child Table Permissions & Multi-Tier Hierarchies

In complex relational databases, child records should not be exposed globally; their access must reflect the security boundaries of their parent entities. Child Table Permissions use the Parent Access Type to create cascading security trees. +-----------------------------------------------------------------------------------+

  • | MULTI-TIER PARENT ACCESS HIERARCHY |
  • | |
  • | [TIER 1: ACCOUNT (Parent Table Permission)] |
  • | └── Access Type: Account Access (Scoped to logged-in user's Company) |
  • | │ |
  • | ▼ |
  • | [TIER 2: PROJECT (Child Table Permission)] |
  • | └── Access Type: Parent Access (Inherits via Project -> Account relationship) |
  • | │ |
  • | ▼ |
  • | [TIER 3: PROJECT TASK (Grandchild Table Permission)] |
  • | └── Access Type: Parent Access (Inherits via Task -> Project relationship) |
  • | │ |
  • | ▼ |
  • | [TIER 4: TIME ENTRY (Great-Grandchild Table Permission)] |
  • | └── Access Type: Parent Access (Inherits via Time Entry -> Task relationship) |
  • +-----------------------------------------------------------------------------------+
  • Rules for Child Table Permissions

A Child Table Permission does not specify an independent access scope (such as Contact or Account); it inherits its scope entirely from its parent.

Child Table Permissions do not need direct assignment to Web Roles. They automatically apply to any Web Role that is assigned to the root Parent Table Permission.

Child table permissions can be nested indefinitely across deep relational hierarchies.

5. Web Roles Architecture

A Web Role in Power Pages is the equivalent of a security role, grouping Table Permissions and Page Access Rules together and assigning them to portal users (represented as Dataverse contact records). +-----------------------------------------------------------------------------------+

  • | POWER PAGES WEB ROLE TYPES |
  • | |
  • | [1. ANONYMOUS USERS] [2. AUTHENTICATED USERS] [3. CUSTOM WEB ROLES] |
  • | - Automatically applied - Automatically applied - Assigned explicitly |
  • | to unauthenticated to ANY logged-in user to Contacts (N:N link) |
  • | public visitors regardless of IdP - Persona-specific |
  • | - Read-only catalogs - Base portal privileges - Partner Admin, Manager, |
  • | - Marketing pages - Profile management Technician, Auditor |
  • +-----------------------------------------------------------------------------------+
  • The Three Types of Web Roles

Anonymous Users Role:

A special built-in role with the flag Anonymous Users Role = True .

Automatically applies to every unauthenticated visitor browsing the site.

Used for public-facing data (e.g., Read permissions on a Product Catalog, Knowledge Base Articles, or Store Locations).

Only one Web Role per website can be designated as the Anonymous Users role.

Authenticated Users Role:

A special built-in role with the flag Authenticated Users Role = True .

Automatically applies to all authenticated users the moment they sign in with any identity provider.

Used for baseline authenticated capabilities (e.g., Read/Write access to the user's own Contact record to manage their profile, Read permissions on general customer announcements).

Only one Web Role per website can be designated as the Authenticated Users role.

Custom Web Roles:

User-defined roles created to implement granular business personas (e.g., "Vendor Manager", "Claims Adjuster", "Billing Administrator").

Assigned to specific portal users by creating relationships between the contact record and the adx_webrole record in Dataverse (via the adx_webrole_contact N:N association).

6. Web Page Access Rules

While Table Permissions secure Dataverse data records, Web Page Access Rules secure the website sitemap and web page URLs themselves. They control whether a user can navigate to a specific web page or edit its contents on the front-end. +-----------------------------------------------------------------------------------+

  • | WEB PAGE ACCESS RULE RIGHT TYPES |
  • | |
  • | [RESTRICT READ] |
  • | - Blocks unauthorized users from viewing the target Web Page. |
  • | - Automatically hides the page from navigation menus and sitemaps. |
  • | - Unauthenticated visitors attempting direct URL access are redirected to Login. |
  • | - CASCADES DOWNWARD: Automatically protects all child web pages in hierarchy! |
  • | |
  • | [GRANT CHANGE] |
  • | - Grants front-end content management rights to authorized portal users. |
  • | - Allows editing page text, images, and snippets directly in the live browser. |
  • | - Typically assigned to Content Authors, Marketing Admins, or Web Editors. |
  • +-----------------------------------------------------------------------------------+
  • Sitemap Inheritance & Cascading Rules

Web Page Access Rules follow hierarchical sitemap inheritance:

When a Restrict Read rule is applied to a parent web page (e.g., /Customer-Portal/ ), all subordinate child pages (e.g., /Customer-Portal/Invoices/ , /Customer-Portal/Support/ ) automatically inherit the restriction.

If a visitor does not possess a Web Role associated with the Restrict Read rule, the parent page and all child pages are completely hidden from navigation menus and search indexes.