"Security constraints prevent access to requested page"

[sigmachiuta]

I have published a report and added it to a dashboard with the role of "public" but i am still receiving an error "Security constraints prevent access to requested page".   I added the role of ITIL to the report and my test user had ITIL, nogo.. So I started debugging security, first I had a read ACL issue with sys_report, so (for testing) I added the role of public to that ACL.   That cleared the ACL issue but the report still wouldn't show.   I navigated to the table with my test user   foo_bar.list and received the same error.   The security debugger shows all green when navigating to the table how can i debug this security issue when navigating to the table doesnt show me any problems, and why did I need to add public to sys_report?   The plugin "Report Security - enforce access control checks" is enabled and my instance is Fuji.   My gut tells me that its a table ACL but with the debugger not showing me what ACL is not evaluating correctly i am at a loss.

[Chuck Tomasi]

Have you checked read ACLs on the table the report his hitting to ensure users can read the records. Your test of foo_bar.list tells me they don't have table or field level read ACLs on those records.

[sigmachiuta]

After looking at this for a while i figured out that the report uses a db view.   The user has access to both tables by typing table.list when impersonating.   So a db view read acl right?   The issue here is that when i go to add a new read ACL on the table its not in the list of selectable tables.

[sigmachiuta · Accepted solution]

for those who might have the same issue, make sure the char count of your db view.......

ServiceNow KB: PRB650194: Database views do not appear in name choice list in ACLs or in table choic...

[Alexey8]

Hi Sigmachiuta! 

Unfortunately I don't have access to this article from HI Service Portal. Could you please explain what is written there?