[jboss-user] [JBoss Seam] - Re: Security: access control at entity level?

[a.simonov]

I have two to tables:

Table1 and Table2 . I have mapped  them like this:


  | @Entity 
  | @Table(name = "Table1")
  | 
  | class Table1{
  | int id;
  | int level;
  | 
  | @OneToMany
  | List<Table2>  items
  | 
  | }
  | 
  | 
  | 
  | 
  | @Entity 
  | @Table(name = "Table2")
  | 
  | class Table2{
  | 
  | int id;
  | 
  | 
  | 
  | }
  | 
  | 
  | 

I woud like to do a filter for Table2 entity which returns same result as this query returns:
select * from Table2  t2 where (select  t1.level  from Table1 t1 where t1.id=t2.id)= :accessLevel


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4050961#4050961

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4050961