Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

How to remove permission for a certain table ?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

Currently, we have super role in Nav which basically mean that users can access all objects in Nav.

Now, we have a special request, that users can access all table except for table A in design object; this user still can run the report/form and get data from this table as normal.

Can you suggest the solution?

*This post is locked for comments

  • Verified answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: How to remove permission for a certain table ?

    Go to permissions and select all the rows and right click. From the menu you can select copy rows. Once you do that all the selected rows will be copied to your clipboard.

    After that create a separate Permission set and paste the rows which you copied previously.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to remove permission for a certain table ?

    Hi,

    I can copied all object and paste to the list of objects for permission; however, I cannot copy all the value for Read/insert/modify, etc to yes

    Can you share me how I can coped these value ?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to remove permission for a certain table ?

    please follow the below steps to copy & create new permission set.

    1. Open permission set and click on permission.

    2. After that select all permissions and copy.

    3. Create new permission set and paste all permission.

    4. Finally remove the object which you don't want to give access and assign to required user.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to remove permission for a certain table ?

    Exactly, but how I can create custom role copied from super role and remove the access to this table? manually adding one table/object at a time is not an option because it's too much; if we have a way in coding to add all the objects then we can manually remove the access for table A then it's a great solution

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: How to remove permission for a certain table ?

    Do you mean the user should have access to all the objects, except table A, from Object Designer? You can't achieve it via SUPER role, you need to create a custom role that would have access to all objects, except this table.

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,130 Super User 2025 Season 1 on at
    RE: How to remove permission for a certain table ?

    you need to create different permission sets and then get all the objects and remove the table/form which you don't want to give access to

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,289 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans