Trace users
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Trace users

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Post

    Hi,

    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...?

    Thanks!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    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

    HTH

  3. #3
    Join Date
    Jan 2000
    Posts
    387

    Cool

    Hi,

    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! :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width