I have set up Label Security in an Oracle 12c database and am trying to make a simple Apex application that will make use of the label policy. I have created a table ('documents') that contains a label policy based on the values in the 'Classification' and 'Compartment' columns in the table. In SQLPlus I can do the queries (SELECT * FROM documents) and get the correct results back (based on which role the user matching into the policy). This all works fine.
I've created an apex application with a simple report view on the documents table. I've changed it to use database authentication for the login. No matter who I log in as I always get no results returned. From reading around on the forum, I believe this is because Apex ignores roles when performing queries (and runs the query as the workspace owner, rather than the logged in user). If this is the case by design, how are you supposed to use Oracle Label Security with Apex? It relies on using roles, so I can't see how OLS can be used. Is there some way to get a report to 'run as' a certain user and pay attention to their roles? Does anyone have an example of using OLS with Apex?