Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / User not authorized error
Microsoft Dynamics AX (Archived)

User not authorized error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have users who are getting the following error:

"User 'xyz' is not authorized to select a record in table ProjPostTransView.  Request denied."

"Cannot select a record in Project transactions(ProjPostTransSaleView), Access Denied: You do not have sufficient authorization to modify data in database"

Not everyone is getting the error.   I have done my due diligence and found the answer regarding AOSAuthorization.  But it is set to "None" on the view.  I looked at the tables that make up the view and they are None too.

I've confirmed no customizations to any of those tables.   I have not yet tried to restart the AOS, but will try that tonight.  No assurance that will work, but I have no better plan at the moment.

*This post is locked for comments

  • Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: User not authorized error

    Dear Brain

    have you please verified this using systems administration role? if its working with administration account then there should be Aos Authorization enable on table. kindly review the complete table you find AOS Authorization property YES on one of the fields.

    For resolution your can review my this post

    community.dynamics.com/.../enable-aos-authorization-field-using-security-privilege

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: User not authorized error

    Hi Brian,

    You can add the table on e.g. the Proj assistant role by overriding the permissions. This will solve the issue. From the Security roles form it is possible to open the form for override permissions.

    I don't know which factbox could cause it. You also did not mention which form was opened and if you have any customizations.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User not authorized error

    Restarting the AOS did not change the behavior.  This user has the following roles

    AP Clerk

    AP Payments Clerk

    Buying Agent

    Cost Clerk

    Proj Accountant

    Proj Assistant

    Purch Agent

    Purch Manager

    Receiving Clerk

    Sales Clerk

    Shipping Clerk

    System User

    Warehouse Worker

    I have discovered that the issue lies in the Fact Boxes to the right.  If they are open the error appears.  If they are closed, the error doesn't happen.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: User not authorized error

    Hi Brian,

    Please inform if the AOS restart solved this issue. Otherwise, please specify if these users do have the same role as other persons or if they are different. Then also mention which form or report was opened.

  • Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: User not authorized error

    Hi Brian

    Probably restart AOS will fix your issue.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans