Symptoms
Non-admin users are unable to see all the (non-active) records in the sys_user table though they have read access.
Release
All the available releases
Cause
There is a query business rule called "user query" on the sys_user table which allows only admin users to view all the records. As you may see in the business rule, the user will need to have admin role to see all the records in the sys_user table. Otherwise, it will return only active records. "addActiveQuery' adds a filter to return all active records.
Resolution
In order to allow all the users who has read roles to the sys_user table to view all the records, the user will have to modify the condition of the business rule to add roles or turn off the business rule itself. The business rule can be found here.
https://<instance-name>.service-now.com/nav_to.do?uri=sys_script.do?sys_id=62a7bfaf0a0a0a6500c49682bd82376a