Report on Dashboard not allowing drill down for other users

Cat · yesterday

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 · yesterday

@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 · yesterday

So the user is not able to see the data for this table; if that is the case, it means the user does not have access to this table.

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

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

Cat · yesterday

Yes, but how do I give them access to the table if it doesn't show as a table as shared in screenshots in my below response to Sandeep Rajput?

Dr Atul G- LNG · yesterday

Search for the table in the application navigator.
Click the pencil icon.
Check which role is assigned there.
Go to the user profile and assign that role to the user.

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

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

Cat · yesterday

It doesn't appear

Dr Atul G- LNG · yesterday

Go to Tables and search for this table; there you will find the role linked with it.

Also, if you are searching by the table name, it may not appear. Do you have a module for this table?

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

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