Use CurrentCEUserName to limit record in LOV

[Former Member]

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

[Former Member]

I figured it out.

Just want to share that it is used in the way it is supposed to be, that is, you can apply filter in the Data Foundation and Business Element and implement row based security which is defined in a database table.

What I did wrong was I put UCase() function before CurrentCEUserName and it becomes a string and thus it didn't do the work.

Kiki