Skip to Content
0
Former Member
Apr 15, 2010 at 03:27 PM

Use CurrentCEUserName to limit record in LOV

36 Views

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