Report on Dashboard not allowing drill down for other users

Cat · 3 weeks ago

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 · 3 weeks ago

@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

Dr Atul G- LNG · 3 weeks ago

Hi @Cat

This means the other user does not have access to that table, which is why they are encountering a security error.

Check @Sandeep Rajput reply

https://www.servicenow.com/community/grc-forum/security-constraints-prevent-access-to-requested-page...

*************************************************************************************************************
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]

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

Cat · 3 weeks ago

The list doesn't appear in Tables it appears under Lists. Is there somewhere to check that?

Dr Atul G- LNG · 3 weeks ago

Any screenshot, mate?

*************************************************************************************************************
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]

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

Cat · 3 weeks ago

Not sure if this helps