APEX

Hi!

I am writing an applikation which requires the user to log on. Dependig on his name he should be able to see different data querying the same database object.
I solved this by creating a temporary table which stores the username along with other information. A view is joining the datatable with this temporary table and thus produces different sets of data depending on the different users.
This temporary table always contains exactly 1 row for each oracle session.

While adding a new user interface build in apex, I encountered the problem, that our apache server is using the same oracle session more than once - i.e. if 2 users log on, there are 2 entries in the temporary table, visible for both of them. This confuses the view, producing mixed-up results.

Is there a way to configure the apache server to ensure that for every user a seperated sql-session is used (and thus ensuring a seperated view on the temporary table?)

In some older posts I found the information that temporary tables cannot be used since apex ist stateless.
But in some later posts, I found that temporary tables are both usable and used in apex.

How should/must I configure my apache/apex application to use temporary tables ?

Thanks, Michaael