Row Level Security in BI Publisher

Hello,

I am trying to setup row level security for one of my BI Publisher reports. This installation is a stand alone Oracle Analytics Server 5.5 on Linux and our user authentication is using an Active Directory provider configured in weblogic.

I am following a white paper from Jan 2009 "Row Level Security with BI Publisher Enterprise".

It talks about enabling the check box for User Proxy Authentication for the data source so that the BI Publisher username who has logged in is passed to the Database and in the RLS policy function, I can check something like:

WHERE ename = SYS_CONTEXT('userenv','session_user');