Even after configuring report_view ACL, user facing issue to view the report

[Dee S]

Hi,

There is a custom table let's say 'u_catalogitem'. This doesn't have any ACLs configured as of now and table is only accessible to admins.

There is a user (who is not admin) asked to create a report of the type list for the table 'u_catalogitem' as he cannot access table.

Even after the report is created he/she will not able to access report due to access issue.

I was suggested to configure 'report_view' acl (admin override is true) - row level (u_catalogitem - None) and add attribute condition as -> Group is 'any one of the user's group'.

Even after configuring the report_view acl. User is still getting an error "Security constraint prevents access to the page".

Is there any way that I can achieve this using report_view acl?

[Hemanth M1 · Accepted solution]

Hi @Dee S ,

You can't view list of records if don't have read access regardless of the report_view.

Why don't you create a scheduled report and send.

Scheduled Report reference: https://developer.servicenow.com/dev.do#!/learn/courses/washingtondc/app_store_learnv2_reportanalyti... 

Hope this helps!!!

[Hemanth M1]

Hi @Dee S ,

Does users have read access to this table??

Use Access Analyser to quickly identify which ACLs restricting the acess.

[Dee S]

Hi @Hemanth M1 ,

Read ACLs are not configured.

I know that if read ACL is configured report_view is not required but I am concerned that user will be able to access the table's data from list view. I should restrict that user should not able to access from anywhere except from the report. 

Can you help me configure like this?

[Hemanth M1 · Accepted solution]

Hi @Dee S ,

You can't view list of records if don't have read access regardless of the report_view.

Why don't you create a scheduled report and send.

Scheduled Report reference: https://developer.servicenow.com/dev.do#!/learn/courses/washingtondc/app_store_learnv2_reportanalyti... 

Hope this helps!!!

[sejal1107]

Hi ,

Try creating report view acl on table (u_catalogitem, None) and

Instead of giving attribute condition try adding any basic role which will be there for all the users which should have access to the table for example roles like "snc_internal"

Make sure report is shared with the intended user.

Please mark helpful if your issue is resolved