Users can't access Database view reports

[Harish74]

Hi there,

I have  created a new Database view(u_demand_metric). From this I have created a Report. As I'm an admin I'm able to see it get control on the filters. But my colleague who is also have an admin role can see it in read only mode but can't filter something. He is getting "Security constraints prevent saving reports - displaying report as read-only". Again some users who doesn't have admin role able to see it and get control on the filters.

I have shared the report to Everyone. After seeing this issue I tried to create an read ACL without a role. This also didn't worked.

 I don't know what's going on. Please help me on this.

[Community Alums]

Hi Harish,

The user might have read access to the particular table but *not* the task table and that is why they see the error. They may or may not need to pass the "report_on" type ACL to be able to create report on the database view themselves.

You need to Create a Read ACL for your users on the tables in a view to generate reports on database views.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Harish74]

Hi Sandeep,

Tell me which role I need to provide.

I have created a Database view joining dmn_demand and metric_instance table. I saw read ACL's of both tables. And the user who is facing that issue passed that roles. 

[SusanWinKY]

Hi @Harish74 - Did you figure this out?

We have a similar issue:

Users have read and report_view access to dmn_demand, metric_instance, and metric_definition. (We created a custom role - metric_reader - for read and report_view access to metric_instance and metric_definition.) We created a DB view that uses those 3 tables. When they view a report based on that DB view, they get the security constraints message if the report is grouped by a field on the dmn_demand table. If they ungroup the report, they can see records in the list but the demand fields are empty. They also see empty demand fields if they go to the DB view table directly to view the list.

[sowmyaprabhakar]

Any responses ? I am facing the same issue. Any recommendations are highly appreciated.