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... / Permission Setup
Small and medium business | Business Central, N...
Suggested Answer

Permission Setup

(2) ShareShare
ReportReport
Posted on by Raja 156
Dear members, 
I have a requirement
 
User 1 must allowed to edit a vendor card or list page but not allowed to modify, edit or create preferred vendor bank account. User 2 must allowed to create, modify or edit a preferred vendor bank account but not allowed to edit a vendor card or list page.
 
Thanks in advance,
Raja.
 
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    PRao Profile Picture
    PRao 447 on at
    Prepared two different user permission set for both user and assign the permission set. 
     
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,210 Super User 2026 Season 1 on at

    You need to have two permission sets as follows:

    User 1 Permission Set:

    • TableData Vendor (23): Permission to Read/Insert/Modify/Delete
    • TableData Vendor Bank Account (288): Permission to Read only

    User 2 Permission Set:

    • TableData Vendor (23): Permission to Read only
    • TableData Vendor Bank Account (288): Permission to Read/Insert/Modify/Delete
     
     
  • Suggested answer
    Satish Srivastava Profile Picture
    Satish Srivastava 242 on at

    1. Understand the Tables and Objects Involved

    • Vendor Card/List Page:

      • Vendor information is stored in Table 23 (Vendor).
      • The Vendor Card and Vendor List pages use this table for display and editing.

    • Preferred Vendor Bank Accounts:

      • Bank account information is stored in Table 287 (Vendor Bank Account).
      • These are managed separately from the vendor card but are linked to vendors.

    2. Create Custom Permission Sets

    You need two custom permission sets to segregate the required permissions.

    Permission Set for User 1:
    • Table 23 (Vendor):
      • Grant Read, Insert, Modify, and Delete permissions.
    • Table 287 (Vendor Bank Account):
      • Grant Read only (no insert, modify, or delete permissions).
    Permission Set for User 2:
    • Table 287 (Vendor Bank Account):
      • Grant Read, Insert, Modify, and Delete permissions.
    • Table 23 (Vendor):
      • Grant Read only (no insert, modify, or delete permissions).

    3. Assign Permissions to Users

    • Assign the custom permission set created for User 1 to the corresponding user account.
    • Assign the custom permission set created for User 2 to the corresponding user account.

    4. Test the Setup

    • Log in as User 1:
      • Verify that the user can edit vendor cards but cannot modify, create, or delete vendor bank accounts.
    • Log in as User 2:
      • Verify that the user can create, modify, and edit vendor bank accounts but cannot edit vendor cards or list pages.
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 25,555 Most Valuable Professional on at
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,817 Super User 2026 Season 1 on at
    The question here is do You really want to block for User 1 option to modify the field Preferred Bank Account on the Vendor card? Or You want to block him the permissions to add/modify the bank accounts registered for this Vendor. 

    If User 2 can create those bank accounts or modify, and user 1 can only provide the already created values on Vendor card, then 2 permissions sets should be easy to set up - as Valentin Castravet already showed in his comment.
     
     
    But if you want that User 1 can create/delete/modify anything in Vendor card, but cannot provide/change value in the Preferred Bank Account field, then You will need to create a modification and add a validation on this fields OnModify trigger. Maybe in User Setup add a field - Allow to change "Vendor Preffered Bank account" and only those users who will have the checkmark in this column in User Setup will be able to change this field.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,949 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,064 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 559 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans