Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Permissions

Posted on by Microsoft Employee

Dear all,

Dince few day, I cannot do any transaction in NAV 2013, system send me this message "you do not have these permissions on TableData..." system send me this message if I want create a new Customer, or a new sale order,...

The licene is ok.

 

Thank you for your help

*This post is locked for comments

  • Suggested answer
    Corina Soare Profile Picture
    Corina Soare 585 on at
    RE: Permissions

    Hi,

    I think this may help you out: mbs2.microsoft.com/.../kbdisplay.aspx

    Please let me know if it doesn't :)

  • Suggested answer
    Miguel Llorca Profile Picture
    Miguel Llorca User Group Leader on at
    RE: Permissions

    If you are sysadmin, run this script on your SQL database:

      delete from [dbo].[User]

      delete from [dbo].[Access Control]

      delete from [dbo].[User Property]

    At this point, you will be back to your SUPER role :-)

    And then you can clear a few more tables, just for deleting redundant data:

      delete from [dbo].[Page Data Personalization]

      delete from [dbo].[User Default Style Sheet]

      delete from [dbo].[User Metadata]

      delete from [dbo].[User Personalization]

    Hope this helps!! Good luck!

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Permissions

    Did you or anyone modified Super role permissions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Permissions

    Dear sir,

    No one can make any transaction in the system. I'm the super User, but since this issue, I cannot do anything in system. for any action I try to do, system give me the same error.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Permissions

    Please contact Super user and ask him to assign Super role to you

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Permissions

    I was super user, but since this issue my role super user is removed, and i cannot assign this role again, when I try system give me the same message error, "you do not have these permissions on TableData..."

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Permissions

    Are you a super user or do have any other roles assigned to you?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Permissions

    System give me error for all tabledata, if i try to create a new Customer he give this error, if I try to create a new User or a new GL account, he give me this error. Anything  I try to do, system give me this error. But I can modify the old transaction for example the sale order which are not already posted I can make a change on it.

  • Suggested answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: Permissions

    Can you please tell us for which tabledata system is giving you an permission error? is it for customer tabledata ?

    Have you done any customization recently ?  

    Please also check permissions against the user.

    Regards,

    Saurabh Shah

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Permissions

    Yes, I can run table or from developpement client

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