My application has certain access priviliges and certain users can only see certain datasets.

For instance 'salespeople' can only see Territory data for territories they are assigned.

Is there a way to apply criteria at the db or session level as opposed to having to do it for all of our queries?

thanks, Tom

AFAIK, there is no way to globally apply a filter to all queries. Might be possbile with AOP, but I'm not sure would want to anyway. I think you are going to need to add it to all your queries, put you could create a helper method that returns a Criteria and then just add that Criteria any time you make a Territory-specific query.