We have an application on the web developed using JSP, Java and with database as Oracle 9i.
Connection to database is made using the database bean with userid as xyz.
So to capture the Audit Information of all DML's performed on certain tables, I need to capture the Application Userid through which the user logged in, not the database userid through which connection is made.
I tried to use, dbms_application_info pkg in 9i but to no avail. Pls advice if any solution is available.