Report on Dashboard not allowing drill down for other users

[Cat]

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?

[Cat]

Have you seen my response? I'm not able to do what was suggested per the screenshots I shared

[Ankur Bawiskar · Accepted solution]

@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! 🙏

[Cat]

This look interesting - let me try this and come back to you

[Cat]

This was it! Thank you so much for your help!

[Ankur Bawiskar]

@Cat 

Glad to help.

Happy learning !