# Private Sign in, Limit Access by Email **URL:** \ **Category:** Ask for Help\ **Created:** [December 17, 2020, 2:54pm UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992 "2020-12-17T14:54:07Z")\ **Posts on this page:** 1\ **Showing post:** 23
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2020, 8:29am UTC](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992/23 "2020-12-18T08:29:39Z")
Okay. Let me first preface this by saying that what follows is not much more than me thinking out aloud, and there is every chance that I could be wildly off base. With that said… I’ll assume first that within your Business Owners table there is a mix of information about each business. Some of this you want to make public, but some should be kept private and only accessible by individual business owners. If that’s not true, then you can probably stop reading here. Otherwise, read on… If there is _any_ private information in the Business Owners sheet, then you _definitely_ should be using row owners on that table. But then, how do you make the “public” information available? This is what I would do: - Create a 2nd sheet, let’s call it Business Owners Public - The first column of this sheet would be an arrayformula, which copies the RowID from the private table - You use this column to create a relation between the two tables - With that in place, you can add a lookup column to bring in each column from the private table that you want to make public - You do not set any row owner on this table, so all data is accessible by anyone Then with the above in place, anywhere in your app you need to display “public” business owner data, you reference this sheet instead of the “private” sheet. This is a very similar approach to what @kyleheney described [here](https://community.glideapps.com/t/action-to-set-column-in-non-row-owned-column/19348), and to my simple mind it is both sound and secure. --- _[View the full topic](https://community.glideapps.com/t/private-sign-in-limit-access-by-email/19992)._