I have a concern about the security of my APP.
I see that this topic has already been dealt with, but honestly I have not yet understood it well.
This is the scenario:
In my APP I’ve normal users and administrative users;
users data are hosted in the table UsersProfiles; all user data has an important level of privacy;
in the APP there is a TAB in which every normal user can view and modify his profile (telephone, address, date of birth, identity document, etc.).
The UsersProfiles table is not protected by ROW OWNERS (because the Admin must be able to access all the records of UsersProfiles) but in the TAB-UsersProfiles the Details is filtered with the “email is signed-in user” method.
What I would like to understand exactly is: the filter “email is signed-in user” acting on the client side or server side? That is, does the entire package of UsersProfiles records still arrive in the user’s device and then only the record that corresponds to the signed-in user is filtered in-App?
If so, I have a security problem.
Someone can confirm/help me to better understand?
And tips for adopting the best levels of data security would be very helpful for me right now.
Thanks @ThinhDinh you are always so willing to give me right answers in zero time.
So I ask you this: if I were forced to set row owners on the User Profile table, I could, in your opinion, with another APP (an admin APP) access the same UsersProfiles table where, however, the Admin has the possibility to see all the records of UsersProfiles?
@Roldy I’m curious what you ended up deciding – Admin app or roles? I’m looking at a similar situation but has not considered that reading the sheet from a different app bypasses the restrictions imposed by the row owner column.