Hi there, I'll mention firstly that I'm still very green to ServiceNow administration, so gentle guidance will be appreciated.
I’m facing a problem with 2 reports in ServiceNow that display data in a bar chart format.
One report is grouped by Producer-Category-Parent and stacked by Producer-Category with table sc_item_produced_record. The other, grouped by Item-Category-Parent and stacked by Item Category with table sc_req_item. The issue is that certain user(s) cannot see the report in their dashboard. The only way I’ve been able to grant access to the report is by assigning catalog_admin permissions, but this feels like over-allocating access to the user, including it’s child role(s) that are inherited.
We’ve discovered that the issue occurs, and the user can no longer see the report when the reports are stacked by the item/producer-category field. We’ve checked that the user has correct ACL’s to the report_view and read on the sc_category table to other roles the user currently has (that including ITIL and sn_request_read). We’ve ran this user specifically through access analyser and all the permissions look to be correct. I've seen a few other posts which I've dabbled in and tried, but I still can't find a solution that's worked.
Let me know if any further information is required, and thanks in advance.
