# I want to allow only specified users to log in to the App

**URL:** <https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124>\
**Category:** Ask for Help\
**Created:** [October 7, 2022, 11:28am UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124 "2022-10-07T11:28:13Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 11:28am UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/1 "2022-10-07T11:28:13Z")

</div>

I am currently on the ProApp plan.

First, I set the publish to private.

After that, I set Users in the users table to the user table and tried to log in, but it says that this email address is not allowed to access, so the PIN code is not sent.

I created a table of email addresses with Any email in table and tried to log in, but I can’t log in with the same error.

Please let me know how can I allow only certain users to login.

---

<div class="post-metadata">

**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:** [October 7, 2022, 12:07pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/2 "2022-10-07T12:07:26Z")

</div>

> [@user.jp](#):
>
> Please let me know how can I allow only certain users to login.

There are a few different ways to achieve this, but let’s use the most common example, which is users that you already added to your User Profiles table. The Privacy settings you need for this are:

- Access → Private
- Sign In → Required
- Users → Users in the Users table

If you can’t get it working, please provide screen shots of:

- your privacy settings
- your User Profiles configuration
- your User Profiles table (from the Glide Data Editor)

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 12:40pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/3 "2022-10-07T12:40:33Z")

</div>

When I set “Access” to “Private”, “Users in the Users table” does not appear in the SignIn options.

On the other hand, if you set “Access” to “Public”, “Users in the Users table” will appear in the SignIn options.

However, this setup does not solve my problem.

 ![スクリーンショット 2022-10-07 21.31.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55eb4ced4bcdab8c0987d0629b72673a74d5adaf.png)  
 ![スクリーンショット 2022-10-07 21.31.10](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/930062c29217827537c4eefd92cca9800f468e0c.jpeg)  
 ![スクリーンショット 2022-10-07 21.31.47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4ac4d14830cf7fc996989c3101c869bcdbb88e86.jpeg)  
 ![スクリーンショット 2022-10-07 21.32.12](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f93feb9f4cc81b548f2f53fdc0a294e1a2d324a.jpeg)  
 ![スクリーンショット 2022-10-07 21.32.26](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd49b74c464771745aa9ef82dc43f6233ab02285.jpeg)

---

<div class="post-metadata">

**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:** [October 7, 2022, 1:21pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/4 "2022-10-07T13:21:09Z")

</div>

Your first two screen shots appear to be from two different Apps.  
They both show Privacy settings, but the first is the new configuration and the second is the old.

So which is the one from the App you are having problems with?

I made a slight mistake with my earlier advice:

> [@Darren\_Murphy](#):
>
> - Access → Private
> - Sign In → Required
> - Users → Users in the Users table

that should actually be:

- Access → Private
- Users → Users in the Users table

Once you select Access → Private, sign in is automatically required, and so the sign in settings are hidden. Apologies for the misinformation.

Anyway, you’ve given two different versions of the Privacy settings, so we need to first establish which is the one you’re actually dealing with.

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 1:36pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/5 "2022-10-07T13:36:09Z")

</div>

The first screenshot is to illustrate the current access settings.

Login fails with the second screenshot setting.

What you told me is similar to the second screenshot setting.

When I try to log in with the second screenshot setting, it says I can’t log in because I don’t have access.

---

<div class="post-metadata">

**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:** [October 7, 2022, 1:51pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/6 "2022-10-07T13:51:22Z")

</div>

ah, okay… I assume that you have added your email address to the Users table?

Can you show me what that looks like? (hide any private info if you need to)

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 2:01pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/7 "2022-10-07T14:01:13Z")

</div>

The user table is set correctly.  
I have prepared a screenshot.  
Could this be possible only with the Private Pro plan?

 ![スクリーンショット 2022-10-07 21.33.14](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/3698418d5a8db4deba73b4137d944af9c1171ab6.jpeg)

---

<div class="post-metadata">

**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:** [October 7, 2022, 2:08pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/8 "2022-10-07T14:08:22Z")

</div>

Okay, as far as I can see everything that you’ve shown me looks correct.

Can you try something please?

Try changing your privacy settings to Public/Optional/Anyone, and see if you can sign in using an email address that already exists in your Users table.

 ![Screen Shot 2022-10-07 at 10.04.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd521ed17d7cb48b410911495cac8f6758bb36c7.png)

I realise these aren’t the settings you want, I’d just like to know if it works.  
If it does work, please check your Users table to see if a new row is created, or whether your login is linked to an existing row.

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 2:57pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/9 "2022-10-07T14:57:46Z")

</div>

I tried the method you suggested, but I couldn’t log in.

I have the user table specified correctly, but it seems to me that the user table is not working.

Is this a bug?

---

<div class="post-metadata">

**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:** [October 7, 2022, 3:15pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/10 "2022-10-07T15:15:40Z")

</div>

I’d be very surprised if it’s a bug, as if it was it would be affecting Glide users all over the world.  
It must be something specific to your App, but at the moment I can’t see what it is.

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 3:38pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/11 "2022-10-07T15:38:12Z")

</div>

For example,

- Access → Public
- Sign In → Optional
- Users → AnyOne

With this setting, I can log in.  
If so, the PIN was sent and successfully added to my spreadsheet.

But the Users settings,

・Users in the users table  
・My team  
・Any email in table

Login does not work properly with these settings.

It says you don’t have access rights.

The user table is set up correctly as you can see in the screenshot above.

I also checked if there was a problem with the text data in the spreadsheet, but I didn’t see any problems.

Should I use the Limit Access Email feature of the Private Pro App plan?

If it is impossible, we have no choice but to implement a pseudo-login function using the VISIBILITY function.

---

<div class="post-metadata">

**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:** [October 7, 2022, 3:51pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/12 "2022-10-07T15:51:10Z")

</div>

Wait…

> [@user.jp](#):
>
> For example,
> 
> - Access → Public
> - Sign In → Optional
> - Users → AnyOne
> 
> With this setting, I can log in.

You told me this didn’t work…

> [@user.jp](#):
>
> I tried the method you suggested, but I couldn’t log in.

So now… tell me… did you look at your Glide Users table after you were able to log in, like I asked?

> [@Darren\_Murphy](#):
>
> If it does work, please check your Users table to see if a new row is created, or whether your login is linked to an existing row.

??

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 3:59pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/13 "2022-10-07T15:59:28Z")

</div>

Sorry, my explanation was bad.  
What didn’t work was

Access → Public  
Sign In → Optional  
Users → Users in the users table

I just wanted to let you know about this setting.

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 4:04pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/14 "2022-10-07T16:04:33Z")

</div>

A new row was created in the user table.

A login is linked to an existing row.

But change it to Private,  
・Users in the users table  
・My team  
・Any email in table  
If you set these three, you won’t have access.

Why. . . .

---

<div class="post-metadata">

**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:** [October 7, 2022, 4:45pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/15 "2022-10-07T16:45:59Z")

</div>

> [@user.jp](#):
>
> A new row was created in the user table.
> 
> A login is linked to an existing row.

um, it can’t be both of the above. Either a new row was created, _or_ the login was attached to an existing row. Anyway, I’ll assume that a new row was created. If that’s the case, that would suggest to me that the email address that you used to login didn’t already exist in your Users table. Which may explain why you couldn’t log in when sign in is restricted.

The next test I would ask you to do is to leave that new row in the users table (ie. don’t delete it), then change your privacy settings back to Private/Users in users table, and then try signing in again with that same email address that you used for the previous test.

I would expect that to work.

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 4:55pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/16 "2022-10-07T16:55:27Z")

</div>

Looks like my explanation was bad again.

In the previous test, no new rows were added.

That is, I found the fact that the user’s data is being referenced.

So I tried the following tests you suggested.

"The next test I would ask you to do is to leave that new row in the users table (ie. don’t delete it), then change your privacy settings back to Private/Users in users table, and then try signing in again with that same email address that you used for the previous test.  
”

However, I still couldn’t log in. . .

---

<div class="post-metadata">

**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:** [October 7, 2022, 5:04pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/17 "2022-10-07T17:04:39Z")

</div>

Okay, we seem to be going around in circles here. If you would be prepared to give me temporary access to your Team & App I may be able to figure out the problem.

Otherwise, it may be best to log a [Support Ticket](https://share.hsforms.com/16jL7NgZYSsW9DinHwTIqZAbvbdc) with Glide.

---

<div class="post-metadata">

**Author:** ![user.jp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user.jp/32/8786_2.png) [@user.jp](https://community.glideapps.com/u/user.jp)\
**Post date:** [October 7, 2022, 5:36pm UTC](https://community.glideapps.com/t/i-want-to-allow-only-specified-users-to-log-in-to-the-app/51124/18 "2022-10-07T17:36:44Z")

</div>

Sorry, we cannot open access to third parties as it contains user data.

Thanks for your support.
