Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

NAV Permissions

Posted on by Microsoft Employee

If I have modify permission to a table does that allow me to delete  from it?

*This post is locked for comments

  • TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: NAV Permissions

    Hi,

    Hope you able to resolve the issue you have mentioned. If so kindly verify the answers.

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: NAV Permissions

    No,  you have all four permission separately to define read, insert, modify, delete but you can make it indirect permission if you don't want to allow direct but want to allow from certain processes.

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: NAV Permissions

    Hello mdycoop,


    You can't delete.

    IF you want to delete then you have to give permission, See the bellow screenshot.

    permission-sets.png

    And one more thing if in Table OnDelete trigger has any code that code also fired. so that code whatever the respective objects there, that you have also need permission.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: NAV Permissions

    As other members mentioned, it would be not enough to have modification rights for deletion. You can also setup a page for editing the table data - pages are objects for viewing and editing data in the RoleTailored client.

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at
    RE: NAV Permissions

    Hi mdycoop

    The Answer is "NO" as others already answered it. if you check in the NAV Permission you can see 4 option 

    1. Read

    2. Insert

    3. Modify

    4. Delete 

    under each of this 4 option if you have value to Yes then you have full table permission do any thing for the records for your understanding please refer the attached image. 

    Permissions.jpg

    Thanks 

    Indika

  • Suggested answer
    RE: NAV Permissions

    Hi,

    No it doesn't allow you to delete.

    In simple words, create, modify, and delete are handled in different triggers in NAV.

    When you are creating, OnInsert() trigger fires, and OnModify() and OnDelete() respectively. You delete create/modify/delete command ends in these triggers.

    If the security filter doesnt allow you to delete, then you cannot.

    Hope it helps.

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: NAV Permissions

    There are Four type of Permission:

    C= Create/Insert

    R= Read/View

    U= Update/Modify

    D = Delete/Erase

    ...

    So if you provide Permission U (for modify) it will not allow you to carry operation permitted by Permission D...

    Hope it answers...

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans