Not authorized to access table ‘Company range’

(0) Share

Report

Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

syed baber 11,633 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 306,697 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

@Andre, thanks, that was the solution.

Was this reply helpful? Yes No