who deleted from a table

[Former Member]

hi

How do I tell which user deleted data from a table ?

Andale

[Former Member]

Hi,

Here is the solution for you.

In order to findout who deleted records or made changes you need to have logging enabled on that particular table. If it is enabled then you can use report RSTBHIST to find out the changes. Also, you cna use this report to find out currently logged tables.

Hope this helps.

Manoj Chintawar

[Former Member]

Thanks gentlemen

@Yoganand Vedagiri my PRD system is set at Not Modifiable . so it can't work

@Manoj Chintawar the table is not in the list of set for logging ie when I run report RSTBHIST my table is not displayed

I hope there is another way

regards

[Former Member]

Hello,

In that case you can't find out who deleted it. Hope this is clear now.

Regards,

Manoj

[Former Member]

Hai,

Users who have access write ABAP programs, has full access to the database and thus can delete all the data.

Additionally users with permission can use SE14 to delete table contents completely.

You can use STAD and ST03 to analyse what are all the tcodes executed in a particular period of time and by which user. Also you can use table logging on tables to log the activities on the table.

http://help.sap.com/saphelp_nw04/Helpdata/EN/7e/c81ebb52c511d182c50000e829fbfe/frameset.htm

Regards,

Yoganand.V

Edited by: Yoganand Vedagiri on Feb 6, 2009 11:54 AM