APEX

Hi,

I am working with a SSO authentication tool that a user is initially taken to its login page. Once authenticated it redirects them to my application, and it sets the value of REMOTE_USER to that authenticated user's username. From there I can let that trusted user enter my application.

The problem I am having is that ApEx seems to be overriding remote_user with APEX_PUBLIC_USER.

When I try to login my session looks like this in ApEx "session detail":
Database Username APEX_PUBLIC_USER
Application Username APEX_PUBLIC_USER

I have put a pl/sql process on the first apex page a user is brought to and it simply inserts
OWA_UTIL.get_cgi_env ('REMOTE_USER') to a debug table, the value that it inserts is "APEX_PUBLIC_USER".

When I login via regular apex accounts my session detail info looks like this:
Database Username APEX_PUBLIC_USER
Application Username JRP



Not sure if it is relevant or not but the SSO product we use is widely implemented here at our university but this is the first time is is being tied into ApEx :(
http://weblogin.org/


Thanks,
Justin