05/04/2023, 2:42 AM
It seems like with this schema I would need to explicitly add users to each resource (every member of an organization for a public item), which seems extremely inefficient. And how would I be able to determine if a resource was public or not? the schema Ive come up with so far is something along these lines: which I think works fine for determining view permissions when I want to query if a particular user has access to a resource, but I also need to be able to tabulate all of the resources available to a user, and whether or not they public(org does not have access to them) or private