Maintaining audit trail(who modified and when modified)
[254 byte] By [chintu123a] at [2007-10-3 0:28:18] 
Hi allI am working on a J2ee project in which i want to monitor audit trails of particular pages ,The back end is oracle 10g.Can u tell me how to maintain audit trail at application level.I want to show audit trail information in jsp pages.
«« Not able to connect to database(MS SQL Server 2000) through JSTL tag
»» looking for free lib for upload files to sftp ?
»» looking for free lib for upload files to sftp ?
save the sessionid, username , logintime, logouttime to your db
jgalacambraa at 2007-7-14 17:21:05 >
That's ok but I want really comprehensive audit trail of data base tables.For eg. If someone changes the value of one particular field then I want current as well as previous value and user who cahnged it over large number of transactions.
chintu123a at 2007-7-14 17:21:05 >
i think you want is a table same as you want to back up and add the four columns that i've said?.. am i right?.. those rows that will be updated will be inserted to the backup table plus the columns that ive said.. (logintime and logouttime excluded sorry)
jgalacambraa at 2007-7-14 17:21:05 >
Actually I want to explain you my situation fully. As my application is going to use LDAP server for authentication and single user database id to connect and perform all operations so this approach will not work. Sorry I should have mentioned LDAP while posting this query.Thanks for ur replies.
chintu123a at 2007-7-14 17:21:05 >
so you are not using jsp and will not have session id?..make a trigger that will call a function or procedure that will save the rows to be updated on the back up table before you make the update (trigger before update)
jgalacambraa at 2007-7-14 17:21:05 >
Enterprise & Remote Computing New Topic
Enterprise & Remote Computing Hot Topic
- how to call stored procedure from postgresql to jsp
- How to read unread messages from outlook inbox without using pop3
- Upgrading to Tomahawk 1.1.3
- JSON on JSP (JDBC)
- Read PDF to Browser
- question about using ejb remote home vs ejb reference
- Dynamicly change SelectOneRadio value in java script function -- Please hel
- Getting troubles in getting the JSP page
Enterprise & Remote Computing
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding