Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do we know that which user made DML transactions recently in a table

DINESH EDVINFeb 20 2017 — edited Feb 21 2017

Hi,

I have one table like Test_table. There are 14 users have privileges to access this table.

One user deleting some records on the Table using DML statement.

I would like know that who made the DML transactions recently on this Table.

And also how to recover that deleted data from that particular table.

Thanks in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2017
Added on Feb 20 2017
9 comments
1,945 views