In my org, Account object have OWD as public read only. And I have a custom object C1 which is a child of Account (Master-Detail Relationship).
If a new record is created for C1, it gets saved at the Account which is in the top of Account Hierarchy.
The problem is, I have sharing rules on Account based on the Field 'Sales Region'.
The user in one region has only Read access on the records in another region.
So, if I have a record for Custom object C1, whose Parent is A1 (Account) which is in one region e.g. Asia, while A1's parent A2's sales region is another e.g Europe. If I try to create an attachment or Notes for a record of C1 which is saved at A2, then I am getting Insufficient previliges Error because the user don't have access to A2.
Please suggest any solution to resolve this. TIA