Getting "Security constraints prevent access to requested page" on Spotlight Report

[mfergel]

Doesn't happen as an admin.  I have an end user, added to all of the "pa_" roles and "metric_admin" role.  When she pulls up the Spotlight->Incident dashboard, she gets a message on the Spotlight Incident List Report (as well as when clicking into the others) saying "Security constraints prevent access to requested page".  The report uses the "incident_sportlight" table as a data source.  However, I can't find that table under "tables".  Just under "tables & columns" and if I try to edit it there, it says no record exists.

[Adam Stout]

incident_sportlight is a database view.  Add an ACL for it like a normal table.  I believe you can give access to everyone as views security still apply the underlying ACLs from the tables in addition to the ACL on the database view.

[mfergel]

OK.  Makes sense as to why I can't find it.  Do I need to setup the ACL's on the root tables that make up that view (as it doesn't look like you can do it on the database view itself).

[mfergel]

I gave the pa_spotlight role access control (all four) on the incident table (already had it on spotlight table) and still not working.

[Adam Stout]

What about the incident_sportlight view?  That is what is missing (and you only need read access).