id summary reporter owner description type status priority milestone component version resolution keywords cc drp_resources i_links o_links remaining_time sprint 117 Push security filters into DB jamoore jamoore "Currently, our filtering is done in the business logic (for all intents and purposes). It should be possible to push that down into the [http://hibernate.org Hibernate]-generated SQL queries. [http://www.hibernate.org/hib_docs/v3/reference/en/html/filters.html Filters] are the name of the game. The main concern is whether or not our queries begin to behave differently once this is put in place. Outer joins may not begin to behave as inner joins as was happening in Omero2. " task closed critical 3.0-M3 Security 3.0-M1 duplicate hibernate,story114