For the purpose of row level security I have an additional user table related to the SFSUsers table with several fields, one of them is a generated where statement. I use this where statement to perform custom fill-methods for forms and reports to control which domain of data the user have access to. This works ok.

Now – some of my users would like to do search/selection via a SF browsedialog, which they know from another application done with SF without this form for row level security. 

The problem is , that the browsedialog as I understand it talks directly to the table, and therefore I cannot use the where statement for the logged in user to do the search.

I thought about having two BO’s of the same type on the form, one to populate from the browsedialog and then in the BrowseDialogClosed event do some check before copying the data to the other BO which databinds to the controls.

Does any of you guys have any ideas on how to do this or maybe a better way over all to accomplish this?

Thanks.

Teddy