question Re: Even after configuring report_view ACL, user facing issue to view the report in Developer forum

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

Dee S — Mon, 19 Aug 2024 10:09:16 GMT

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?

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

Hemanth M — Mon, 19 Aug 2024 10:35:59 GMT

Hi @Dee S ,

Does users have read access to this table??

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

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

sejal1107 — Mon, 19 Aug 2024 10:37:37 GMT

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

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

Dee S — Mon, 19 Aug 2024 10:54:10 GMT

Hi @Hemanth M ,

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?

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

Hemanth M — Mon, 19 Aug 2024 16:14:03 GMT

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_reportanalytics_washingtondc_reporting_and_analytics/app_store_learnv2_reportanalytics_washingtondc_data_visualization/app_store_learnv2_reportanalytics_washingtondc_scheduled_reports

Hope this helps!!!

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

Dee S — Thu, 17 Oct 2024 03:05:31 GMT

Update on the question asked:

As @Hemanth M mentioned here, You can't view list of records if don't have read access regardless of the report_view. Report_view ACL is basically to restrict report access.

So, read access should be given and then report_view acl should be created and given to the required roles