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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (14)

Answers (1)

Muzzafar.Jahangir 2 on at

Like (0)

Report

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

I faced the same issue in one of our security roles in D365 F&O, and I fixed it by referring to the correct security privilege in the custom-developed security roles.

1. Identify the security privilege associated with table "CustParameters"
2. Add the security privilege to the effected D365 Security role. "Maintain account receivable parameters" / "View accounts receivable parameters".
3. Publish the role.
4. Reproduce the issue, and the error gets fixed.
Suggested answer

Shyam Mani 331 on at

Like (0)

Report

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

Hi,

You can choose to delete entity specific usage data by filtering in the "Usage data" form, under tab "All usage data", field "Company". That way, your Users will shout less. Or more precisely you can filter by "Element name", and delete the usage data.

Regards.

SM
Community Member Microsoft Employee on at

Like (0)

Report

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

Thank you for all your help, since it's an usage data issue my company decided to just clear the usage data of all the users that are having this issue. Thanks again for your time.

Best,

Mariam
Verified answer

Sohaib Cheema 46,610 User Group Leader on at

Like (0)

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

Hi,

One approach that may work, since/because it is problem of usage data and NOT security related, so you can login on AOS, with a userId, who is facing issue. You can turn on debugger and can narrow down to corrupt entry of usage data. you can assign admin right to such user temporarily for debugging. Also you need to add that user to debugging group.

There can be another approach , which can be quite hard;

You can also use, kind of, hit-and-trial approach. For example you can take stack Trace, or in simpler words you can take list of all those objects which are involved while user tries to open SalesTableListPage. Preparing such a list of object may contain, forms such as SalesTableListPage, different tables which come under query of this LisPage.

By taking all those objects which come from the time when user open SalesTableListPage till error display, you can delete usage data of each object one by one, as you can filter usage data by object names. After deletion of each entry, you can Test if issue is resolved or not. You can repeat this for all objects, unless you get correct results. Doing so, can bring you record of usage data, which is creating problem.
Community Member Microsoft Employee on at

Like (0)

Report

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

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?
Sohaib Cheema 46,610 User Group Leader on at

Like (0)

Report

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

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.
Community Member Microsoft Employee on at

Like (0)

Report

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

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.
Sohaib Cheema 46,610 User Group Leader on at

Like (0)

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

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
Community Member Microsoft Employee on at

Like (0)

Report

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

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.
Suggested answer

Hajish 460 on at

Like (0)

Report

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

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.