The ask is to make all records in a report visible to all users irrespective of their assigned roles.
Ex: Create a report with name 'read_all'
User A(Admin role) should be able to see all records in the report 'read_all' (Say, User A is seeing 50 records)
User B(ITIL role) should be able to see all records in the report 'read_all' (User B should also able to see 50 records)
Please follow the below steps to witness this behaviour. Below steps are replicated for the table 'incident'
1. Sharing by user, group, or role, is the primary method of sharing reports. You can use access control lists (ACLs) to control access to the underlying table or database view data. Users are able to view reports when the user does not have access rights to a data record in a data source or source table of a report. However, they are not able to see that record in a list view or in a drill-down view. Database-view-list reports require the reporting user to satisfy ACLs on the target data to view records in the list. Users without sufficient permissions see filtered list reports.
2. ACLs for a table do not propagate to database views based on that table. Database views require separate ACLs.
3. Creating an ACL with no roles may impact security and integrity of the records
4. It is always a best practise to implement this solution first in SUB-PROD and notice the behaviour for at least few days with multiple users