setabort action not working for delete

[ABC6]

i have to restrict non admin user to stop deleting attachment from std_change_record_producer for which i have written below code against std_change_record_producer its a before delete, please let me know where i am doing wrong , even log is not generating for the same

[Ankur Bawiskar · Accepted solution]

@ABC6 

The lead should already know the reason.

Reason is the delete actually works on sys_attachment as attachment is getting deleted and not the actual record on which the attachment is present.

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

[SanjivMeher]

Your business rule should be on the sys_attachment table instead of std_change_record_producer.

Deleting attachment will trigger BR in the attachment table. Make sure to add appropriate condition in the BR on the attachment table.

[ABC6]

i have to do with the same, please expedite my query

[SanjivMeher]

You can't on std_change_record_producer, since the BR wont trigger. 

Your lead need to understand what is feasible. Another option would be to use access control on attachment table, to not allow delete if table is std_change_record_producer. It would be more complex, since attachment is a system table and you will have to be careful while adding ACLs and need proper testing.

[ABC6]

Any specific reason for this , please let me know