# How to limit access to data?
**URL:** https://community.glideapps.com/t/how-to-limit-access-to-data/56957
**Category:** Ask for Help
**Created:** [January 21, 2023, 11:28am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957 "2023-01-21T11:28:51Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 11:28am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/1 "2023-01-21T11:28:51Z")
Hello!
I would like to make a restaurant listing app. I am interested in how to make a database so that each restaurant can edit its own data and does not have access to the data of other restaurants.
Thank you!
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 21, 2023, 11:29am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/2 "2023-01-21T11:29:54Z")
row owner, role, or filters
---
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 11:33am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/3 "2023-01-21T11:33:02Z")
How do I determine who is the row owner?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 21, 2023, 11:33am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/4 "2023-01-21T11:33:31Z")
by user email address
---
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 11:34am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/5 "2023-01-21T11:34:46Z")
OK, thanks! I will try, should the database be made in glide or in google sheets?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 21, 2023, 11:35am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/6 "2023-01-21T11:35:41Z")
always go with google sheets… the most reliable service in the World… plus you can do real magic with sheets formulas and scripts.
---
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 11:39am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/7 "2023-01-21T11:39:18Z")
Can you please describe to me how to make each restaurant see only its data? Then the restaurant enters the data in the app or in a Google Sheet?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 21, 2023, 11:40am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/8 "2023-01-21T11:40:22Z")
assign the owner’s email to each restaurant… but there is a bad side to this method… that’s why I’m not a big fan of the row owner function… it blocks the whole row. So you gonna have to recreate accessible info in some other sheet.
---
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 11:44am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/9 "2023-01-21T11:44:28Z")
Which method do you recommend? And how do I do that?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 21, 2023, 11:46am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/10 "2023-01-21T11:46:22Z")
hmm… I have a very unique and complicated method… LOL
> **[External Data Source](https://external-data-1.glide.page/)**
>
> Multi Spreadsheets Data source for Glide Pages with Stripe and PayPal integrations, Address Picker, Custom Emails, PDF Invoice Creator. Unlimited rows and updates.
---
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 11:48am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/11 "2023-01-21T11:48:43Z")
It looks complicated 🙂
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 21, 2023, 11:53am UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/12 "2023-01-21T11:53:39Z")
don’t worry… in a few minutes… (or more) some of the big writers, will write a whole manual on how to make your question work using just Glide… i’m out for today 😉
---
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 12:19pm UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/13 "2023-01-21T12:19:14Z")
Thanks!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 21, 2023, 4:27pm UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/14 "2023-01-21T16:27:34Z")
> [@Simon\_Marence](#):
>
> I would like to make a restaurant listing app. I am interested in how to make a database so that each restaurant can edit its own data and does not have access to the data of other restaurants.
If you need this to be secure, then you would need to make use of the [roles](https://www.glideapps.com/docs/reference/security-and-user-data/roles) feature.
Essentially you would define a role for each restaurant, assign the appropriate role to each user from each restaurant, and then use those roles as row owners.
For example, imagine that you have Restaurant A and Restaurant B. You might define something like role `resta` for Restaurant A and `restb` for Restaurant B. All users that belong to Restaurant A would be given the `resta` role, and all users from Restaurant B would get `restb`.
Then in the table/s that contain the Restaurant data, you would have a row owner column. Data that belongs to Restaurant A would have `resta` in the row owner column, and data that belongs to Restaurant B would have `restb`.
Using this approach, the data for each restaurant would be siloed, and it would not be possible for users from one restaurant to access data from any other restaurant.
It should be noted however, that every user that is assigned a role would be counted as a private user, even if your App allows anyone to sign in.
---
### Author:  [@Simon\_Marence](https://community.glideapps.com/u/Simon_Marence)
#### Post date: [January 21, 2023, 5:52pm UTC](https://community.glideapps.com/t/how-to-limit-access-to-data/56957/15 "2023-01-21T17:52:23Z")
Thank’s!