User Permissions for Data

[JordanBrooks]

I've built a territory management app that has multiple tables (org, users, stores, listings, contacts, visits, etc). I waited until the end to add the user permission slices and am now getting an error when creating the slice and adding the security to the users table.  Apologies for the repetition but this is the error:

Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Error: Data table 'Users' is not accessible due to: Server was unable to process your expression, it may be nested too deeply........................................................................................... ?

I can't find any info on tables nested too deeply. Any ideas?

[dbaum · Accepted solution]

In my experience, the first thing to check is whether there's a circular reference in a table security filter. It's easy to end up with that tables like org and users, and AppSheet isn't good about flagging this condition. Confirm that any rows (from the same or a different table) referenced in a security filter expression can be loaded by the app without first evaluating that security filter expression.

[JordanBrooks]

Thank you. Was a very easy fix, removed the client table altogether as it was redundant.