Database Table Access Log

[Former Member]

Hi All,

Can anyone explain me how to get the details of access history (Not change log from CDHDR table) of a table in the system?

For Ex: We would like to get the details of who all accessed the table BKPF from last one week.

I have tried in ST03 and STAD transactions, but did not get any such access log.

Looking towards your help,

Regards

Pavan

[Former Member]

Hi Pavan,

I think the closest thing you can get is the t-code ORA_PERF.

In the tree, select Performance -> SQL Statement Analysis -> Table Access.

There you will find the details of access to the database tables since the last start up.

Hope this helps you.

Regards.

João Soares.