Ingenio wrote:DB account authentication only uses the DB account for authentication purposes, not to establish a connection to the database. APEX requests always run using ANONYMOUS connections from the pool. In the APEX session the <tt>APP_USER</tt> substitution string will contain the name of the database user used to authenticate.
For auditing, I need to insert the user, among other data, into different tables.
The thing is, I have an application with DB account authentication, so a real database user is connected, when auditing, the user field inserted is "ANONYMOUS".
i need to audit the real user, is it possible?Use the following expression in the audit code to return the username: