Hi Praveen, I'd recommend you to create one filter that runs "on delete" and pushes information such as "who", "form name" and some info into separate table. Share this filter between all important tables. Also create one more filter on this new table and send email to yourself "on submit". This would not prevent deletions, but you would always have information about deletion in all important tables.
HTH Mike From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Praveen Saraswat Sent: Monday, October 15, 2018 6:42 AM To: arslist@ARSLIST.ORG Subject: Data drop from tables Hi Team, Looking forward for suggestions on how to strengthen the data security in remedy. Last week someone did a mischievous job in the environment by deleting all the data from 4 table from Production. Unfortunately, no user logs were enabled from database nor from application. There were few ids with administrator access enabled from previous application owner. Is there any way we can trace down the actual suspect? For remediation, we have revoked all the administrator access except for the required ones. Enabled SQL User logging but it will eat up resources and impact system performance due to the log size. Also, we have written workflows to disable deletion on all important forms. Is there anything which we can do avoid such data glitches. All suggestion will be much appreciated. Regards, Praveen Kumar Saraswat
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist