Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

hello! i'm a bit confused about RLS. because the users table is schema of public, can anyone see all other user accounts?

Hello <@403366964669579266>!
This thread has been automatically created from your message in <#843999948717555735> a ``few seconds ago``.

Pinging <@&951828363943759883> so that they see this as well!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ... menu) and select **Leave Thread** to unsubscribe from future updates.

**Want to change the title?**
Use the `/title` command!

**We have solved your problem?**
Click the button below to archive it.

also,  i don't think i'm even using that users table?? i dont have any other tables, but there's nothing in it, the users only show up in the authentication tab.

If you have a public users table you likely created it. If you go to schema auth, that user table should have your auth user data.   There are examples to use a trigger function to copy to a public user or profile table some info if desires.   The API does not have access to the auth schema.

so if i delete the users table where does the user auth data go?

yeah i must have created it with the User Managment Starter in sql editor

Auth.users you can see it in the table ui if you pick the schema

wow okay yeah im blind i see it now thanks

There are several schemas for different things the API by default has access to public

so RLS is disabled on the users table, is this because its not user accessible? so it cant just be accessed using the anon key right?

That is also why you might want a public profile table you can use RLS to control.

as in it's all behind the supabase auth api

great, thanks for your help that makes sense now haha

Thread was archived by <@403366964669579266>. Anyone can send a message to unarchive it.