Users are not able to view survey results

[Donald Jayawar1]

Users are not able to view survey results report built on asmt_metric_result table.

The same report can be viewed by the users in UAT but not in production. The roles allocated to the users are same in both environments.

When I assessed further, I found out that the users cannot read data from asmt_assessment_instance table as well in production. But they have access to both tables in UAT.

The error users are seeing when accessing the report:

Access to this content denied based on report_view ACLs.

When we assign the role assessment_admin to the users, they are able to view the reports in production. But wondering what other privileges they get as a result of this new role.

As per the above, I have two questions:

1. Why the users can view the report in UAT but not in production when they have same roles in both environments?.

2. Can the users modify/delete records when they have the assessment_admin role?

[RaghavSh]

Check for Read ACL on "asmt_assessment_instance" table. with read acls they will only get access to read and not update/delete

[RaghavSh]

@Donald Jayawardena were you able to get this resolved?

[Donald Jayawar1]

Hi Raghav,

Thanks for your reply. I do not have elevated access to security_admin user. Therefore, I am not able to create ACLs.

Further, my main question is how the users can see the assessment tables in test/uat/dev but not in production. As per the users, they were able to access the tables in production as well.

Would you be able to show me how to troubleshoot the issue?

[Donald Jayawar1]

Thanks Raghav for your reply. I am wondering how I can create Read only ACL as I do not have access to Security_admin role in UAT or production. Can you please share with me any other way I can create the ACL?

Further, is assessment_admin role can give the users unnecessary privileges?