Interesting dilemma. The File_c which is used for attaching files at the field level needs some additional functionality to manage who sees what.
The issue is that the object doesn’t inheret any sharing rights as it’s the record being referenced as a lookup. There really really needs to be some additional considerations to manage this when using this object. Any solution I think of is quite a bit of a hack. Updates to sharing of any kind wouldn’t stay in sync with the File__c record.
Really stumped on this one.
Question
Skuid File__c object sharing rights when File__c needs to be set to Private in OWD
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.