Symptoms

Admins are unable to see the records in table:

-- They are getting "Number of rows removed from this list by Security constraints: 20" Error when trying to access table or a record

-- After debugging ACL you noticed Admin Override is checked, that means admin should pass that ACL

Cause

-- System Property 'glide.security.admin.override.accessterm' is false. 

-- This property when set to false means, if there are number of ACLs on the same table/field and admin override is false on one of them, then admin override for all ACL's are considered as false. 

Resolution

1. Search for the system property 'glide.security.admin.override.accessterm' in sys_properties table:

https://<your-instance-name>.service-now.com/sys_properties_list.do?sysparm_query=name%3Dglide.security.admin.override.accessterm&sysparm_first_row=1&sysparm_view=

Change value from 'false' to 'true'

2. If the property is not available on the instance you add this property, with details:

Name: glide.security.admin.override.accessterm

Type: true/false

Value: true

Description: When it is set to true, it evaluates the admin overridable condition at access term level.  

Additional Information

Here you can read more about this system property: Admin Override Property