Users are not able to create report on sn_grc_issue table

[Majji Koteswar1]

Hi Team,

Users with compliance user role along with reporting capabilities are not able see "sn_grc_issue" table while creating report on the same. When I checked the ACLs, I can see report view ACL with "sn_grc.reader" role. Also, I don't see any custom ones are created and all are OOB. However, They can access the table and view the records. Could you please let me know what actions can be taken further?

Thanks,

Majji

[Robert H]

Hello @Majji Koteswar1 ,

Which reporting roles do the users have exactly?

OOTB any user with sn_grc.reader and report_user roles is able to see this table when creating reports.

Have you checked if there is a report_on ACL (not report_view) on that table?

Regards,

Robert

[Majji Koteswar1]

Thank you @Robert H for the response. Users have "report_user" role related to reporting. Also, I don't see any report_on ACL on "sn_grc_issue" table. Please let me know if there is anything I need to check. 

[Robert H]

Hello @Majji Koteswar1 ,

Are there any report_on ACLs on the parent tables (planned_task, and task)?

Have you tried creating a report_on ACL on sn_grc_issue that lets everyone pass, to see if this resolves the issue?

Regards,

Robert

[Majji Koteswar1]

Hi @Robert H

I don't see any report_on ACLs on the parent tables. I will check with team on creating an ACL on Issue table since I don't have rights. Thanks!