Report on Dashboard not allowing drill down for other users

Cat · Friday

We have a user who has added a chart to a dashboard as a widget. When they click on any of the bars, it takes them to a page with a list view of that information. However, when someone else on their team clicks on the bar, they get a message: "Security constraints prevent access to requested page"

The users have access to the Dashboard and chart - why does this occur for them?

Ankur Bawiskar · Friday

@Cat

it looks like that is a database view joining multiple tables and hence not showing up in the Access Analyzer

share how your report is configured

Is it using some group by etc

In left nav search database view and search that here

-> try creating that table.None READ ACL with snc_internal role

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Cat · Friday

When I search for it, it doesn't appear. This is why I'm so confused:

The ones I've blurred are not what I am looking for

Dr Atul G- LNG · Friday

Hi @Cat

Is this a system/custom table, or did you create this table yourself?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Sandeep Rajput · Friday

@Dr Atul G- LNG Thanks for the mention. @Cat The user who are seeing this issue may not have read/report_viewer access to the underlying table.

To debug the ACL issue, you can use Access Analyser to find the problematic ACL.

Cat · Friday

It shows here as a table:

But not here:

Ankur Bawiskar · Friday

@Cat

Approach shared by @Sandeep Rajput to debug will lead you to identify the root cause and the fix

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader