Symptoms

Admins are unable to see the records in a 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 that, if there are a number of ACLs on the same table/field and admin override is false on one of them, then admin override for all ACLs are considered as false. 

Resolution

1. Search for the system property 'glide.security.admin.override.accessterm' in sys_properties table:
   • https://<instance-name>.service-now.com/sys_properties_list.do?sysparm_query=name%3Dglide.security.admin.override.accessterm
2. Change the value from 'false' to 'true'
3. If the property is not available on the instance you can add it with the following 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 the access term level.  

Additional Information

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