Restrict non itil users to from drill down into Reports

Dwain Bryden
Tera Contributor

Hi Guys,

I have create a ACL to restrict non itil users from drill down into Reports, but somehow seem to know working accordingly. 

Please see, any help is appreciated. Thanks

find_real_file.png

1 ACCEPTED SOLUTION

Strictly speaking, there is not a way to restrict drill-down.  The only thing that can actually be restricted is direct access to view the records (the actual list of records or the form).  

ACLs control access to the underlying table data. List reports require the reporting user to satisfy ACLs on the target table to view records in the list. Users without sufficient permissions may see filtered list reports.

Reports that present aggregate data, such as pie or bar charts, do not require the user to satisfy target table ACLs to view the chart. These reports are not filtered due to security, though may be filtered with ACLs or before query business rules defined for the target table. ACLs are required to view the list of records when you click on a portion of a chart.

The way this works in practice is that a user can see the pie chart, bar chart, etc.  They can even drill down into the 'Other' category to see a sub-section of the chart.  If they ever click down far enough to actually display a list of records they will be restricted based on the ACLs in place for the rows in that table.

Please mark my response as correct if I've answered your question.  Thanks!

View solution in original post

5 REPLIES 5

Rob,

I don't know if you ever figured out your problem, but i had the same problem.   I finally found this article to solve the issue.

 

Apparently, if you have a drilldown report (or report in general) pointing to multiple parent reports, it fails.  I wasn't sure how i had the same report being a drilldown to multiple parents, so i just deleted and recreated with a new name.

 

https://hi.service-now.com/kb_view.do?sysparm_article=KB0717091

 

"User unable to access drilldown report, but has access to the parent report"