We are using an LDAP authentication scheme.
For direct access, users enter their username and password and APEX sets the APP_USER to the username provided -- we want this.
For simulated single sign on, though, where we use an impersonation LDAP account and then set some global variables to ID the user logging in via SSO, the APP_USER is set to username that corresponds to the impersonation LDAP account.
How can we set the APP_USER in APEX 4.x?
We've tried all of these, but none seem to work:
HTMLDB_CUSTOM_AUTH.set_user( 'my_test_user' );
WWV_FLOW.g_user := 'my_test_user';
WWV_FLOW.g_current_user := 'my_test_user';
Here is a nice blog about how to achieve LDAP Authentication and Authorization within APEX. I think this might help you.
+If the question is answered please change it to answered and mark the appropriate post as correct/helpful.+