We want to perform a search across three objects - ObjectA, ObjectB and ObjectC.
So we created a Business Object Group - Group1 - containing these three objects.
So far so good, because we can write a query on Group1.
The problem we have is that we want to restrict some users from searching ObjectC, as it contains sensitive information.
The problem is easy to solve in SQL, but the tool doesn't support SQL involving groups.
Has anyone had a similar problem?