I have a method that calls Oracle db to return a subset of data - for example row 41-51 of a list of users. everytime I click next, the class calls oracle with for the next ten users. Basically oracle is providing the paging. I would like to return only the rows which the user has access to, so it is not rows 41-50 that I am returning, but rows 41-50 of the data that the user can see. since oracle does not know who is authorized or not, I need to filter the list returned by oracle. If I use @PostFilter, then oracle returns rows 41-50, and Postfilter removes the rows that the user is not authorized for. Unfortunately, the user sees less than 10 rows he is expecting.
My question is, does @PreFilter work for me, where the user gets back exactly 10 rows of the data he is allowed to view everytime he clicks next.