Issue with ACL on reports

[Dileep Kumar2]

Hi Guys,
We have see an issue when users access reports.
Here is the error:

Security constraints prevent saving reports - displaying report as read-only

Access to this content denied based on report_view field ACLs.

May I know why this is happening.

[Dr Atul G- LNG]

Hi @Dileep Kumar2 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0826549

Resolution

To fix the issue, add the system table to the system property "glide.ui.permitted_tables". This property contains a list of system tables (beginning with "sys_", comma separated), that are reportable. As it was mentioned previously, by default, system tables are not reportable. 

System Property "glide.ui.permitted_tables" URL:
https://<instance-name>.service-now.com/nav_to.do?uri=sys_properties.do?sys_id=c3dee8670a0a0aa70064b48de5ad973e

Go to the ACL table, open the Reports view under the table’s operations, and check which roles are required.

[Dileep Kumar2]

We already added approval table in the permitted tables.
Issue is with ACL. But its hard to figure it out.

[Dr Atul G- LNG]

Hi @Dileep Kumar2 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1639061

[Ankur Bawiskar]

@Dileep Kumar2 

create report_view ACL on sysapproval_approver table and add snc_internal role and then see

also use access analyzer to debug ACLs

[Vancouver Release] Customers gain enhanced access visibility with ServiceNow Access Analyzer 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏