Have you looked into Local Authorization? https://www.osohq.com/docs/develop/facts/local-authorization https://www.osohq.com/docs/develop/facts/local-authorizat

Have you looked into Local Authorization? https://www.osohq.com/docs/develop/facts/local-authorization https://www.osohq.com/docs/develop/facts/local-authorization it lets you apply authz filters to paginated search over a database, even if some of the data the authz depends on isn't stored in the database