on 02-09-2007 7:49 AM
Dear Friends,
Some body has delete some entry from perticular table, i want know who has deleted and when.
How?
Sachin
Hi Sachin,
If log is maintain for that database table ,you should be in position to see the changes made otherwise it is not possible.
<b>Log data changes</b>
The logging flag defines whether changes to the data records of a table should be logged. If logging is activated, every change (with UPDATE, DELETE) to an existing data record by a user or an application program is recorded in a log table in the database.
Note: Activating logging slows down accesses that change the table. First of all, a record must be written in the log table for each change. Secondly, many users access this log table in parallel. This could cause lock situations even though the users are working with different application tables.
<b>Dependencies</b>
Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.
The existing logs can be displayed with Transaction Table history (SCU3).
<b>
To check whether log is maintained or not.</b>
Go to SE11 transaction.
Give table name .
Click on Technical Settings
You will get a check box in bottom Log data changes.You can see F1 help on this check box.
regards,nishant
please reward points if this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
goto se11 and give the table and goto attributes tab and see last changed by
samrat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.