Granular permissions on table fields

(4) Share

Report

Posted on by CPRM

108

I need to remove permissions from table fields and only leave one of the table fields editable. Someone knows how to do it in Business Central V25

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Bilal Haider 414 on at

Like (2)

Report

Hi,

There are two ways to do it.

One way is through development. You can make editable property of those fields to false in table extension or set them dynamically based on conditions.

Other way is to use Lock editing property on UI. But this is not a security layer and users can modify it. You can do it either only for one user or for all users linked to a profile. To do it for your own user go to top right bar and then click on gear icon and open Personalize. Page will be in personalize mode. Click Lock Editing to make field un editable.

To do it for all users related to a profile, go to profiles and click customize page action. Then the changes you make will be pushed for all users related to that profile.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,750 Super User 2025 Season 2 on at

Like (2)

Report

Unfortunately, there is no field-level permission control in the BC standard function. In addition to the method mentioned by Bilal, you can also consider third-party add-in.

For example,

https://appsource.microsoft.com/lv-lv/product/dynamics-365-business-central/PUBID.fenwicksoftware%7CAID.fg03%7CPAPPID.9c635c18-e65b-4aba-b78c-e35552de4c60?tab=Overview

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

There is no field permission on standard BC.

You can check App Source for field permission functionality or you can build yourself.

https://appsource.microsoft.com/en-us/marketplace/apps?search=field%20security&page=1

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,384 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Field Level Permissions (Restricted Fields) | MSDyn365 Business Central - Tom Kapitan

Business Central 2023 wave 2 (BC23): Customize field editability from UI (Lock editing & Unlock editing) | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No