I want to hide the “Monetary Benefit” report for users who are not the Project Manager of the related project.
To achieve this, I created a Read ACL at the table level on the benefit_plan_breakdown table. The intention is to restrict read access for users who are not Project Managers, so that the data inside the report is hidden, without hiding the entire report itself.
When I open the table list view, the records are correctly hidden based on the ACL.
However, when I open the report, the same data is still visible to those users.
Why does the report still display data even though the Read ACL is working correctly on the table?
Is there an additional configuration or best practice required to ensure that ACLs are enforced on reports as well?
