Row level security is not applied in Webi report

[former_member196948]

Hi All,

I have an issue

Environment - Business Objects 4.2 SP 3

The SQL generated in Web Intelligence (Webi) report query panel it shows that row level access restriction created at Universe are not applied. For Administrator it works well.

I found resolution:

Log on to LaunchPad with a user other that Administrator.
Create a Web Intelligence report with the fields with access restrictions applied at Universe.

Note: Observe the SQL generated by the query. It does not show the restrictions applied (no ‘Where’ clause)

Cause

The user does not have enough rights on data access.

Resolution

Log on to Central Management Console (CMC).
Go to Universes.
Right click the Universe and select User Security.
Select the user and click Assign Security.
Click Advanced tab and then Add/Remove Rights.
In Add/Remove Rights window on left hand side expand System and select Universe
In right side pane it shows specific rights for Universe.
Explicitly grant the Data Access right and Edit Access Restriction right
==============================================

I followed the instructions above, but the issue is still there.

May i get any help to resolve above issue.

Regards,

Jeet

[sateesh_kumar1]

Hi Jeet ,

We observed similar kind of issue on 4.2 update . That time we resolved it by , opening , refreshing the document and saving it back to platform .

Not sure this helps !! did you try recreating restriction at universe

Regards

Sateesh