If security of user data is important, another option that’s commonly employed is to create a separate “Public” profiles table. See below for gory details:
Hey fellow Gliders!
Are you using Row Owners and Public Profiles to secure your user data? If not, you might accidentally expose private info. Let’s fix that.
In this important tutorial, I demonstrate how and why to enable Row Owners, create a Public Profiles table, and onboard new users in order to safely create a community app that doesn’t reference the User Profile table.
[Glide: Secure Your Data with Row Owners and Public Profiles]
You can also reference this article in…