Request denied when modifying Report Query: XREFTABLERELATION

(0) Share

Report

Posted on by DPetrov

140

Greetings

What exact Permissions do we have to add to a user group to overcome this message:

User 'UserName' is not authorized to select a record in table 'XREFTABLERELATION'. Request denied.
Cannot select a record in Table relations(XREFTABLERELATION). Access Denied: You do not have sufficient authorization to modify data in database.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Vish Ganesh 30 on at

Like (0)

Report

Re: Request denied when modifying Report Query: XREFTABLERELATION

Give the following security access for the group.

Select Security from the viewing tab.

Select devleopment module

Select tables and give edit access and give read access to the table relations table.

Was this reply helpful? Yes No
dynamics developer 2 on at

Like (0)

Report

RE: Request denied when modifying Report Query: XREFTABLERELATION

This works but now the user doesn't have access to add tables to the query. Any other security node that needs to be activated?

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report

RE: Request denied when modifying Report Query: XREFTABLERELATION

Hi,

Please find the below link:

https://community.dynamics.com/ax/b/ax2012exceldataimport/archive/2014/02/02/microsoft-dynamics-ax-2012-excel-add-in-security-roles-add-tables-add-data

Was this reply helpful? Yes No