0 Replies Latest reply on Jan 19, 2004 9:19 AM by Alexey Pismenskiy

    Many-to-many relations with 3 entity - possible?

    Alexey Pismenskiy Newbie

      Is it possible to create a container managed relations for three entity beans? For example, I have three table
      user (id, name)
      1, bob
      2, alex
      .....
      privilege(id, desc)
      1, read_only
      2, write
      ....
      acl(id, type) (Access List)
      1, 'File'
      2, 'FTP'
      ....
      and 4th table to link it together
      user_access (id_user, id_privilege, id_acl)

      How can I do this on CMP 2.0 ?
      Any ideas? Links?
      Thank You.