Assuming that you are talking about DB Audit software (not DBUPDATE) you can use the user-defined procedure hook that would allow you to map database sessions to your web application user IDs. Most people use the following method. When user logs on to the application they save in some database table user name, logon time and session id. When users through the application or directly make changes in the database DB Audit calls user specified procedure and that performs does lookup for the real user name using current database session id as a key and returns found name to the DB Audit. As part of the audit record in the audit trail the mapped user name is saved along with the database user name, session id and other data. As you can see this processing is really simple and easy to setup. To ensure optimal performance the "logon trail" table can be purged on the fly or periodically. : I have a client-server web application. : The client is JSP based web application with various steps ( say step1,2,3 : etc) involved. The web page is a form which is accessed by multiple users : at the same time at different steps. : The server application reads the data sent by the client and updates a IBM : DB2 database 8.1. : The database updates are carried through a generic ID and not the actual user : id of the user. : When a page is loaded for the first time, we populate the data from the : database. Users may update some fields on the form and the data is updated : to the database. : Now, I would like to find out and see if your dbupdate can help me find out: : 1.userid ( not the generic ID that updated) of the actual user : 2. date time : 3. Fields updated by the user with before and after values : The client-server web application is already running application hence I have : little flexibility to change and major modification to the code is not : possible. : Any ideas how dbupdate can be used for this purpose
|