Hi, Gurus,
I'm trying to tie the security roles defined in Oracle database with LOV in Business View.
What I want to achieve is that LOV should show only a list of values that a user can see based off the privilege set up in Oracle table. So, I used filter in Data Foundation and Business Element and set the field to be filter by CurrentCEUserName.
However, when testing the parameter in Crystal report, I still got a full list. It did seem that the user privilige was tied to the LOV.
Anybody can shed some light?
Thank you so much.
Kiki