RE: Find who deleted records from a table - Help please

From: Ruel, Chris <Chris.Ruel_at_lfg.com>
Date: Wed, 11 Jul 2018 17:42:40 +0000
Message-ID: <SN6PR08MB423939DB45C2E7EFC65AC1999B5A0_at_SN6PR08MB4239.namprd08.prod.outlook.com>



Looks into Oracle LogMiner. That may get you want you need.



Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Manjula Krishnan Sent: Wednesday, July 11, 2018 1:34 PM
To: ORACLE-L <oracle-l_at_freelists.org> Subject: Find who deleted records from a table - Help please

***This email is from an external source. Only open links and attachments from a Trusted Sender.*** Hi:

We dont have auditing turned on. DB is in archive log mode. Yesterday someone/something deleted 12 records from a table and I need to find who.

Can someone help me please?

Thanks,

Manjula
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 11 2018 - 19:42:40 CEST

Original text of this message