Does spicedb have standard approach of implementing dynamic permissions? Namely best way to create dynamic permission sets or relations that would be used during querying or created ad hoc.
I'm thinking whether using caveats for dynamic permissions is at all valid use or would it have very bad performance implications.
Let's say we would have a single relationship defined in schema between resource and user, and we would differentiate between what kind of permission the user has by checking for that relationship but with caveat.
So it could be a check for "has access" with caveat context "admin" that would then check that relationship exists with caveat context as "Admin" for that user.
We are exploring how explicit vs generic we could be with SpiceDB, and at what cost, considering multiple third party domains defining their permissions.
Or should we go with extreme explicitness like an example for modeling Google Cloud IAM.