Error Message - User Unable to see records under sc_cat_item_user_criteria_mtom table

[Community Alums]

Hi,

Created report on sc_cat_item_user_criteria_mtom table , But User is getting bellow error on report 

Error MessagePart of the query on sc_cat_item_user_criteria_mtom has been ignored because of read security rules on sc_cat_item_user_criteria_mtom.sc_cat_item.sys_scope.

PFA and give me the solution.

[Mark Manders]

This means that your user doesn't have rights to see (at least) one of the fields you are using in the query for the report (probably the user criteria you are using). Create a (report_view) acl for the user to see this field as well.

[Harish_K07]

Hi Akhila,

That is because there is a 'Read' ACL on sc_cat_item_user_criteria_mtom table with a role in it.

If the user is not having that role then this error message will be shown.

> Open ACLs and check Read ACLs on sc_cat_item_user_criteria_mtom table.

> Check for Roles in it and give the role to required users.

Mark as correct and helpful if it solved your query.

Regards,

Harish

[Community Alums]

Hi Harish,

we have 2 read acl on sc_cat_item_user_criteria_mtom this table, User already have roles mentioned in the acl's and I tried by creating report_view ACL on this table.

Still user getting his error

Thanks.

[Mark Manders]

"Part of the query..." what exactly is your query on this report, because this user does not have sufficient rights for something in that query.