Privacy rules for uploaded files

Need help Database
1

Hi - I am creating an app which has users, who are members of a Company. I would like to be able to upload files to my app; and then make them available to users from specific Companies. For example:

  • File 1 might be visible to users from Company 1 and Company 2; while
  • File 2 might be visible to users from Company 2 and Company 3.

I can’t work out how to manage the privacy settings to achieve this. If I make the document private when I upload it, then I have to select a “Thing” to attach it to. But if I attach it to, say, Copmany 1, then it becomes impossible for me to subsequently expose it to Users from Company 2.
And the files are confidential so I don’t want them to be visible to everyone.

Anyone know how to solve this? Thanks

2

The privacy rules are set by data type and field are more to do with protecting data and access to fields at the database level. To manage access to records, you should either have a permissions field, or have a separate permissions data type to manage permissions for each record. you will likely also want to manage who can manage the permissions on each record.