Is it possible to show data in report if there are ACL restrictions?

[ServiceNow SA]

Hi Team,

As per requirement, there are record level access on the table based on user role. Some users do not have permission to view those data.

We have query business rule and ACL in place for that.

However is it possible to show the reports based on all table data to those users? Basically there should be no restriction in report data for those users?

[johnfeist · Accepted solution]

If you are asking if the users who are restricted by ACL and query BR can see those data in a report the answer is no. Query BRs run at a lower level than reporting and ACLs run below that.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[Pranesh072]

It is not possible, you are using query BR and ACLs for a purpose. If user can use list view in reporting he will be able to see all those records which will be breach of security.

Dont understand report different from listview, both have to fetch the data from tables and respects the restrictions.

[Ankur Bawiskar]

@ServiceNow SA 

I think it is not a valid business use-case.

Business team wants users to view the reports on few tables without having READ Access to those tables.

Regards
Ankur

[ServiceNow SA]

User has access to the table but not on all records. They can only read records which they have been assigned to.