I am facing situation where data in collection is not loading.
Logged in user has application role CCC_TargetsystemReadOnly which has all requied permissions on table.
I have collection and this collection is bound to grid and data is loded from database(automatic load) -- No data get loaded in collection.
When I assign CCC_DIMAdministrator then above condition works.
When I load same collection on event then it gets loaded in collection. In this case person has only CCC_TargetsystemReadOnly application role.
Logged in user has all view permissions on tables.
Please comment your suggetion what is wrong in first case why it is not loading data in collection.