We have strong interest to work with hibernate in our new project.
But I am still confused about tables relationships with foreign key or without defined primary or unique key.

Can work hibernate with table, which don`t have any primary,unique key, only foreign key???
How its *.hbm.xml look like in this case?

We have problem when we try to use hibernate on customer`s database schema where a lot of tables does not have defined primary key although some of them have unique indexes. For example there exists table USER with defined PK. There exists another table ACCESS_RIGHTS which has foreign key to this USER table but the table does not have PK itself.

Have you any idea???
thanxs for answer.

FAQ: http://hibernate.bluemars.net/117.html#A21

Well you can define a compound key over the fields that make up the unquie combination. The relationships are mapped as you normally would when using a compound key.