web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to allow a user to...
Small and medium business | Business Central, N...
Suggested Answer

How to allow a user to create a record but without the rights to edit the existing records

(0) ShareShare
ReportReport
Posted on by Arnaz De Jesus 10

Hi i was wondering if this is entirely possible,

What i want to achieve is.

User A can Create and Edit a Customer Record

User B Can Create and cannot Edit a Customer Record.

I tried playing around the permission sets but i think the Modify Permission is required to be able to insert a new record.

Is this achievable?

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,161 Moderator on at

    It is possible. But you have to build a layer between user B and the customer table.

    Typically you can build that is not using the customer table as the dataitem. But have the variables defined that match the data you want the user to register in the customer record. Then you let code on the page do the insert in the customer record. And you give the page it self permissions to insert and edit in the customer table.

    Then the user can have indirect right to create and edit customers.

    You can read more about indirect permissions here.

    docs.microsoft.com/.../devenv-permissions-property

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    Hi,

    It is possible.

    Create "Restrict Customer Modify" Field in User setup and write code on "OnModify" trigger of Customer Table

    UserSetup : Record User Setup

    Code:

    UserSetup.get(UserId);

    if not UserSetup."Restrict Customer Modify" then

      error('You do not have permission to modify.);

    Regards

    Amit Sharma

    www.erpconsultors.com

    linkedin.com/in/amit-sharma-94542440/

    Pls press Yes if Info is useful.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,970 Super User 2026 Season 1 on at

    Hi, Yes, it's possible, the easiest way is what Amit mentioned, adding controls in different triggers.
    But this requires customization.

    More details:

    pastedimage1661469921479v1.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Arnaz De Jesus Profile Picture
    Arnaz De Jesus 10 on at

    Hi, thanks for the detailed solution but i was hoping if you can help me more about it. Where should i create the "Restrict Customer Modify" is it on User Setup Page or User Setup Table?

    Thanks

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    Hi,

    Follow the below steps:

    1. "Restrict Customer Modification" field in User Setup table and same display in User Setup Page by using extension of both object

    2.  Write code on "OnModify" of Customer Table by using Customer Table Extension.

    3. Code already explained in the pervious reply.

    Regards

    Amit Sharma

    www.erpconsultors.com

    https://www.linkedin.com/in/amit-sharma-94542440/

    Press Yes Button if info is useful.

  • Arnaz De Jesus Profile Picture
    Arnaz De Jesus 10 on at

    Hi, already created the "Restrict Customer Modification" field for user setup, however i cannot seem to access the C/AL code from my object designer, is that where i can input the code you provided? If yes is there a problem on my license since the C/AL code option is greyed out.

    Thanks

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    Hi,

    Dev license is mandatory for doing the recommended customization

  • Arnaz De Jesus Profile Picture
    Arnaz De Jesus 10 on at

    IMG_2D00_0c267c3df2b6f4458d1220ba495a36e0_2D00_V.jpg

    Hi this is the one included on my license please kindly check if i am allowed to do the customization with that license. 

    Thanks

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    hi,

    No. This is user license not development license.

    Regards

    Amit Sharm

    www.erpconsultors.com

    linkedin.com/in/amit-sharma-94542440/

    Press Yes if info is useful.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,161 Moderator on at

    You will have to be on a version that supports the AL programming language in order to do customization with out a development license.

    So you will need to purchase that granul to have it added to your license.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,161 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,046 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 932 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans