topic Re: Database Table Access Log in Application Development and Automation Discussions

Database Table Access Log

Former Member — Thu, 11 Jun 2015 12:07:11 GMT

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 — Thu, 11 Jun 2015 13:15:13 GMT

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.