SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DBUPDATE: how to use / customize

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DBUPDATE: how to use / customize
Author Message
ucbus



Joined: 05 Jul 2005
Posts: 8

Post DBUPDATE: how to use / customize Reply with quote

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


Tue Jul 05, 2005 3:07 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: DBUPDATE: how to use / customize Reply with quote

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

Tue Jul 05, 2005 4:07 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.