I need to get 50 different people to see the content of an app - and only allow download of information to those people.
If I have public app (email login) and I want to use row owners to restrict peoples access to rows (and download of the rows) then I will need to create an array column (based on a google sheet) on all tables that I want to restrict access to?
|Name||User (row owner)||User1||User2||User3|
|Data||User (row owner)||User1||User2||User3|
|my private email@example.com,firstname.lastname@example.org,email@example.comfirstname.lastname@example.orgemail@example.comfirstname.lastname@example.org|
So is that the way to do it?
And - that is why you would like be able to use roles - and therefore buy a private pro plan?