How to find changes done for a table

[Former Member]

Hi All,

We have a customized trasparent table , for which table log is not maintained. There is a change in data for this table and we want to find out who has done the changes and when .

We are using SAP R/3 4.6c with Oracle 8.1.7

Please let us know if there is any way to sort this out .

Regards,

BN

[stefan_koehler]

Hello Nayak,

as you told us that it is a customizing table .. there should not be many changes.

If you don't activate the table log ... then you can only go over the logminer of oracle (it is much easier, if you know a timeframe in which the data maybe changed):

http://www.oracle-base.com/articles/8i/LogMiner.php

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1154.htm#i1408263

=> TIMESTAMP

=> TABLE_NAME

=> SESSION_INFO

=> SQL_REDO

=> SQL_UNDO

You will not see which user has done the change but you will find the abap program and with that information you can go to ST03n and have a look which user called this program.

Regards

Stefan

[Former Member]

check with your DBA if auditing is enabled, if it is enabled you can get the infromation from aud$ or dba_audit_trail views and you don't have to go through log mining.