[eluser]80onelove[/eluser]
Here's one I've been mulling over for a few days:
I'm working on a group blogging platform. I have a table for users and a table for blogs, which are joined by table blogs_users.
Users has many Blogs
Blogs has many Users
Now, I'd like to grant different privileges to different users on different blogs. Here's an example:
User_1 is joined to Blog_1 and Blog_2, but is granted Level_2 privilege for Blog_1 and Level_4 privilege for Blog_2.
Can this be achieved using DMZ? Or can it be accomplished merely using DataMapper? I've been toying around with this for a while, and the only solution I can come up with is having a privilege table with columns for user, blog, and privilege, but I'm wondering if this is redundant?