I want to know whether it is possible to keep track of the user who have modified a record in the database. I need to know what is the data before change. Any log? Anyway of rollback after the person has updated in teh database and i think it has been commit too...?
in Oracle 8i there is a utility called LOGMINER which decodes redo log and archive log files and from there you can track database activity although not for each user but for the whole database. It also provides the statement to undo a statement, for example if you see an insert 2 days ago by user X at time 20:00 logminer will provides with a delete statement for in order to undo that insert
Thanks for the reply and it is something interesting that i did not know! :P Anyway, may I know where and how to access to this LOGMINER please? What if the record had been updated, am I able to rollback the record even it has been commited 2 days ago? Thanks! :)