DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Tom Vogt[/eluser]
posting here as well, since this thread seems to be active:

I’m wondering if this can be done with DMZ or if I have to add yet another table:

I have a user table and an object table that are joined via a join table, due to a many-to-many relationship (a user can have access to many objects, each object can be accessed by many users).

I would like to “qualify” the type of access that a user has. This is not a generic role that spans objects, but is always object-specific. So user A may be admin of object B, but only a regular user on object C.

My intuitive solution was to expand the join table by an access level, i.e.

Code:

object_id
user_id
access_level

But I have not found a way to use this through DMZ. Did I miss something, or is there a better way to do it?