Hello, we have a dashboard that hosts a report widget of results from the live_message_tag table. The report displays all results where tag = opslog and created within 24 hours ago.
As an admin, I have no issues viewing the results of the report on the dashboard:
Any other user that is not admin cannot view the results due to security constraints:
I have checked the ACL on the live_message_tag table, and tried adding a role that all our users have (ITIL) to the ACL, but still it didn't allow them to view the results. I then toggled "Active" to false on the ACL completely, and users STILL cannot view the results, so I'm led to believe this ACL is not what grants access to view the results of this report on the live_message_tag table.
Can someone recommend a different location to check permissions etc.?
**Update - I have granted all users that should be seeing these results the "live_feed_admin" role and it still is NOT working. They cannot view results.
The ACL you already have is not for the table. It provides access to all the fields on the table. Since you dont have one for the table the default rules will apply. So please create one with access to table.
It should be Live Message tag> --None--
PFA
Hi
I hope you ll see this.
I have a similar problem. When I opened Report ACL Dashboard, there were total of 187 reports that were affected by ACLs. However, I did the same what you suggested in the previous post and now the impacted reports are down to 186. But still when I am trying to do the same for incident_sla table it is showing no change. I am not understanding how to reduce the count of reports and what went wrong. If ypu have any idea please let me know.
For example this report:
Table ACL link:
I have opened Itil Role ACL:
I have attached these pictures to let you have idea about my question.
Thank you in advance.
