Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Not authorized to access table ‘Company range’

Posted on by Microsoft Employee

Hello all!

I have 5 companies in my database, a user always runs the fixed assets movement report in 2 of the companies, but she wants to run on another company and she's getting this error message "

You are not authorized to access table ‘Company range’ (TmpSysQueryCompanyRange). Contact your system administrator." Please what can I do to resolve this, thanks! I have granted her access to all the companies. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not authorized to access table ‘Company range’

    @Andre, thanks, that was the solution.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: Not authorized to access table ‘Company range’

    Hi DammyT,

    Can you verify if the user has the role System user assigned? Also check if this all applicable organizations are assigned on this role.

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,625 on at
    RE: Not authorized to access table ‘Company range’

    Hi Dammy,

    Try to add the duty SysServerAXBasicMaintain under user's role and then give it a try.

    Please verify and let me know if you have further queries.

    thanks,

    Baber.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans