I have a sceanrio where database view is created on 3 tables viz. sn_hr_core_case, metric_instance and metric_definition and a report is created in one of the dashboards to show record counts from this database view.
When a itil user pulls up this dashboard, a multi pilot table report with count based on this database view shows up data just fine but when this user clicks on one of the count to go to the list view (databse view), it opens the database view and says 'No records to display'. This user has read access to recrods on these bases tables. As admin I can see the records just fine.
Database view configuration:
As ACLs cannot be applied on database view, what other possible sollution will work.
Thanks
