Hi Swathi,
OOTB "sys_attachment" table application access setting prevents deletion of records from other scoped apps. I have shared more details here.
https://community.servicenow.com/community?id=community_blog&sys_id=44ad22a9dbd0dbc01dcaf3231f961921
- Pradeep Sharma
