VPD and Context With Application Express

Question

I'm going to build application using Application Express and Oracle Database Enterprise, VPD Implemented on the schema using Context, for developer issue I set on login trigger to set user;

but I can't view data inside application but I can view it using SQL statement

So is their issue in Apex when using VPD , Context , or On log on trigger?

Answer 1

Probably to do with when the logon trigger is executed.

Generally a web-application (including Apex) won't have a database session for each user connected to the application. Rather it will have a pool of database sessions (perhaps 10) and will use any one of them when an end-user issues a database request.

Which database user is used for the logon and how many sessions might be used should all be configurable depending on how you are implementing Apex (embedded PL/SQL gateway, Apex listener or Oracle HTTP server)

In short, a logon trigger is probably the wrong place to set the CONTEXT variable.