Report View ACL Effects?

chuckn · ‎08-05-2022

We are having an issue that I believe is related to report view ACLs (RVAs), but I can't tell for sure.

We have a user who has been granted a custom role that has report_view access via custom ACLs to asmt_metric_result and asmt_assessment_instance. We can create reports on each of the asmt_metric_result, asmt_assessment_instance, and task tables, and said user can see all relevant data. However, in a report on asmt_metric_result that is grouped by Instance (reference to asmt_assessment_instance) -> Task (reference to task) -> Task Type, the report results are removed due to security constraints:

Has anyone experienced something similar? Any ideas on what's required to address the issue?

Thanks!

chuckn · ‎11-28-2022

Ah, yes...I should have updated the post! We created a Now Support Case. Turns out we needed to create a read ACL for asmt_assessment_instance and ensured the users had the role we added to that ACL (in this case we have a role for RVAs for Assessments). Hope that helps!

-Chuck

View solution in original post

Thomas_Davis · ‎11-28-2022

@martapenzo do you have any insight into this question?