Hi, I have an RLS policy set, and I want to use the JS client to query data from the table. I have my service role key. Where exactly do I pass it so that it can bypass the RLS? Here's my JS code:

js
await supabase.from("integrations").select();

And here's the policy:

sql
CREATE POLICY "Don't allow anyone to read" ON public.integrations USING (false);

Thanks for your time, and please ping me 🙂

Using service role key to bypass RLS policies

I'm inviting users manually from the dashboard. How can I allow them to sign in with a magic link only the first time? (because I force them to add a password after the first time)

@User you're inviting them from the dashboard via an email link?

yes

Can you have the magic link redirect them to a password form?

and then have a normal email password login form that they can use thereafter

sounds great thx!

Anyone else having problems with

pg_net

not firing requests?

I wanted to thank everyone who helped me out yesterday. I was having so many problem, but because of this group's help, I finally learned how to properly read the docs and understand how to get started.

pg_net not sending requests

Hey Supabase community, I'm here again for asking a question related to Storage I'm uploading a file as per the documentation, the

.upload('filename.png', File)

and everything. But, I get a 400 error. Any ideas?

The bucket is set to public, too

I'm also getting a "new row violates row-level security policy for table \"objects\""

I'm also getting this error

js
error: ""
message: "new row violates row-level security policy for table \"objects\""
statusCode: "42501"

Found the problem. It was a policy one, as the error suggested

Hey everyone 👋 we have an app with few thousand users and use Firebase currently. We’re very interested in Supabase as an alternative (mainly for a sql database instead of Firestore, which we’ve had issues scaling with), but we need a way to import our users from Firebase Auth. We use phone auth, Google, and Apple currently. Is it possible to import those users into Supabase?

Import Auth from Firebase

Hi everyone! I accidentally deleted the

auth.users

table in my testing environment 🥲 It's a silly mistake, and I was wondering if there's a command I can run to place it back? I tried searching for it in the discussions but to no avail. Thank you for your help in advance! 🙂

It’s probably best to just delete that project and start a new one.

Oh okay! Would you know if there's a quick way to export the sql file for the other tables?

Use a standalone sql app like TablePlus to do that

Got it, thanks for the help!

BUG Session and user return null even when the user is logged in

^ this issue has been driving me ABSOLUTELY INSANE lol

Does anyone have any ideas why

supabase.auth.session()

and

.user()

both return null even when the user is logged in?

There’s no way to wait for the value to be retrieved and then continue with a function to redirect the page accordingly (or whatever else)

SSR Auth

This issue just started happening running supabase locally. I tried to reset my local database. When using

supabase.auth.signUp()

the user no longer gets created in the auth table. The emails still gets sent out. to localhost:9000. Currently supabase version 0.5.0

figured it out. it was a local version of postgres that was hijacking the connection to the docker container