Open
Description
Is your feature request related to a problem? Please describe.
Currently, Permify's data filtering doesn't fetch items sequentially since it runs the search concurrently.
I assume that the order might be non-deterministic (although, I'm not sure).
This might make it hard to solve the problem of filtered searches. See:
- https://openfga.dev/docs/interacting/search-with-permissions (This is the most complete explanation of the problem)
- https://authzed.com/blog/acl-filtering-in-authzed/ (another take on the issue)
Describe the solution you'd like
I would like to hear Permify's take on how to filter data on based on user permissions.
What are the options that you see when using Permify?
Which one would you recommend?
Describe alternatives you've considered
All the approaches described in:
- https://openfga.dev/docs/interacting/search-with-permissions (This is the most complete explanation of the problem)
- https://authzed.com/blog/acl-filtering-in-authzed/
- https://www.osohq.com/post/authorization-logic-into-sql