User [User_ID] is not authorized to select a record in table 'CustParameters'. Request denied.

(0) Share

Report

Posted on by Community Member

Hi all,

I just recently started working with AX permissions and I came across a very strange error that I haven't found a solution to, hopefully someone here can help. Some of our users, while trying to access all sales orders (that they have been able to do without any issues in the past), just started getting these errors saying:

"User [User_ID] is not authorized to select a record in table 'CustParameters'. Request denied."

followed by

"Cannot select a record in Customer parameters (CustParameters). Access Denied: You do not have sufficient authorization to modify data in database."

The strange part is that some users get these errors but not all, out of two users with the same roles one might get it and the other one doesn't.

Please let me know if you have any insight in why this could be happening.

Thank you,

Mariam

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (1)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report
If using same roles, is resulting in problem, for few users only, as compared to users who are not getting issue; this is something fishy and it may need debugging also at some point. Few things which needed to be checked as initial review:

Is kernel version same for all users? Or users who are facing issue, may not have old kernel.

Have users multiple roles?

Have you enabled any security polices recently

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

1. The kernel version is the same for all users.

2. They do have multiple roles but out of two users with the same multiple roles one faces this issue when the other doesn't

3. We haven't enabled any security polices recently.

This is a very confusing issue to me since I don't even know where I should start debugging. It doesn't make sense why one user would get this error when the other one wouldn't with the same roles, I also tried to test that combination of roles and I couldn't replicate the error.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

1) What do you see, 'CustParameters' permission level if you open override permission form?

2) How exactly the users get error? I mean, what they click or try to do, as they get error message?

Was this reply helpful? Yes No
Fredrik Sætre 12,644 on at

Like (0)

Report

Is one of the two users global address entry related to a customer?

Was this reply helpful? Yes No
Suggested answer

Hajish 460 on at

Like (0)

Report

Use the same account(username and password) in any other pc.

If the user is not get getting any error please delete the user profile from his system.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

1. What do you mean exactly? Permissions on the table itself? The AOSAuthorization option? Or is it something else?

2. They get the errors once they click on orders without trying to make any changes to them.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report
I am talking about override permissions screen. That can show you if a role has read access or no access or view access for a table for a particular security role. I believe you haven't customized table to change AOSAuthorization property so we can ignore that point.

Out of box, standard system provides access of CustParameters to following role(s). Do your users has any other roles, other than listed below?

Collections manager

Accounting supervisor

Accounts receivable manager

Accounts receivable manager

Accounting supervisor

Collections manager

Compliance manager

Accounts receivable clerk

Accounts receivable manager

Accounting manager

Accounts receivable centralized payments clerk

Collections manager

Accounts receivable manager

Accounting manager

Accounting supervisor

Warehouse manager

Accounts receivable manager

Accounts receivable manager

Sales manager

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I checked the override permissions form and it has a view access level. My users do not have any of those roles but the strange part is that they never had this issue before and it randomly started showing up without any changes being made. Now some users who have been getting this error for couple of weeks randomly stopped getting them and other users who haven't been getting this error just now started getting them. They all share the same roles.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Can that be because of usage data. Have you tried by deleting usage data of any user, who is facing this issue.

You may keep backup of DB, before doing so, as you users love to shout sometimes, if usage data is deleted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We just tried deleting one of the user's usage data and it did fix the problem for her, the issue is that we wont be able to delete everyone's usage data who is having this issue since the users DO love to shout when the usage data is deleted haha

Do you think there is any other way to fix this problem without deleting the user data?

1 people found this reply helpful.

Was this reply helpful? Yes No