The Resource relates to Action as M:M via Permission join table/separate entity. User can have many permissions. The same permission may be assigned to multiple users.

How to define User-Permission relation as M:M? How would it look like in EF?

erd diagramm


Just an idea - should there be a terenary relationship in there? There seems to be a three way relationship between the resource, permission and the user.

  • Yes, it seems to be a ternary relationship. – lexeme Jan 15 '15 at 7:43
  • Just don't know how to deal with (join) tables? – lexeme Jan 15 '15 at 7:44
  • Can you show the tables in logical form? there are not fks there. Did you add in the terenary relationship. If normalised properly the JOIN query should be simple. – Treasa Jan 15 '15 at 12:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.