Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

How to remove permission for a certain table ?

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
    TharangaC Profile Picture
    TharangaC 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 59,135 Super User 2024 Season 2 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans