Skip to main content

Notifications

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... / Editing only 1 Table D...
Small and medium business | Business Central, N...
Suggested answer

Editing only 1 Table Data Permission

(0) ShareShare
ReportReport
Posted on by AntonisK 222

Greetings to all of you!


I have a user of mine who is granted with the SUPER Permission set.

Due to that , he has Object ID 0 , on tabledata.

pastedimage1663568368220v1.png

I need to restrict the instert and modify permission of this user, on a single tabledata ( to be precise, the sales price tabledata).

I tried doing that by copying the super permission set. However, as far as i know , the below setup , won't restrict the user from inserting data to the table.

pastedimage1663570099592v1.png

So , which is the best way to achieve my goal?

Thank you all in advance.

With respect,

Antonis

  • Pushparaj P Profile Picture
    Pushparaj P 205 on at
    RE: Editing only 1 Table Data Permission

    Hi,

    You Don't Have to Add All Table data Permission Manually, Instead You Can Use Permission Set Or User Group.

    Then You Can Remove the Super Permission and Modify the Mentioned Table Data Permission As You want.

  • AntonisK Profile Picture
    AntonisK 222 on at
    RE: Editing only 1 Table Data Permission

    Let me see if i understand what you are saying.

    So , i created , a new permission set. I added there , only the tabledata for sales price and removed the insert/modify/delete permission.

    Then i assign this permission set to the needed user , who now , has both this permission set and the super permission set.

    The result are the ones below :

    https://prnt.sc/SRBPf1WESq6p

    As far as i know , if the one permission enables the user, and the other one restricts the user, in the end , the user , has the permissions to perform the action.

    Due to that , the result is not the desired one.

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,029 on at
    RE: Editing only 1 Table Data Permission

    Hi,

    Do one thing, Create One Permission and assigned new permission set in the next line, means after the super permission.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • AntonisK Profile Picture
    AntonisK 222 on at
    RE: Editing only 1 Table Data Permission

    But,  if i do so , then i need to go manually , and add the insert/modify/delete permission , to each end every tabledata that the user interacts with. Right?

    If that's the case, this is really time consuming , considering that i only need to restrict the permissions in a single tabledata..

  • Pushparaj Profile Picture
    Pushparaj on at
    RE: Editing only 1 Table Data Permission

    Hi,

    When you Give user a Super Permission, It means the user can delete, insert, modify any data in any table.

    So If you want to Restrict him , You Should Remove The Super Permission From him.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans