How to retrieve the deleted records in Security by design table??

[Nithya Devi]

One of the user have deleted the record in SBD table before two days on Prod env. How to retrieve the deleted record??Could anyone suggest how to fix this.

Thanks with Regards,

Nithya.

[Chaitanya ILCR]

Hi @Nithya Devi ,

if the audit is enabled on that table you can go to Deleted records module and filter with your table name 

and see if you can find those records and you can undelete them (there is an UI action)

if the table is not audited there isn't much we can do

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[RaghavSh]

1. Go to "sys_audit_delete" table.

2. Look for the deleted record with filters like "create by" the user who deleted and "created on date".

3. Open the record and select "undelete record" UI action.

4. If there are multiple records, you can undelete/recover  the from list view.

[Ankur Bawiskar]

@Nithya Devi 

I agree with what @Chaitanya ILCR has mentioned.

If my response helped please mark it correct and close the thread so that it benefits future readers.