How can I disable access to database by any user? Not even allow to edit their profile?

I want to allow my server only to edit it.. I'm not sure if there is any Admin SDK equivalent?

Just enable RLS to all tables

You just need to use the

service_role

secret

instead with the JS SDK, please only use these in a server side environment, you don't want these leaking to the client.

Thanks again! I thought if the admin sdk was different than js client

No its the same library, just different api keys being passed to it

Noobest Question, How do I connect supabase to my domain😁

At the moment Supabase doesn't host your project so you don't do things like CNAME setup with it, however you will need to setup Site URL and additional redirect URLs if you are using Supabase Auth. You can get to this by going to Authentication/Settings inside the Supabase Dashboard.

Yup, I found the Site URL. But didnot know its purpose. I can write any URL without verification

Hi folks, how do you imports to auth from firebase? I already exported users from firebase auth and now i would like to import them to supabase but so far found no api to basically insert into private users db.

Site URL for verifying domain requests are coming from

There are a number of discussions on the Supabase GitHub Discussion board that can help with this https://github.com/supabase/supabase/discussions

Not quite what I was looking for. I can call them but there’s no docs on how to make them. I figured out that it’s just making a function in Postgres, but more docs would be nice for newcomers

Hi guys; I'm running into an issue with creating a foreign key in the table editor. Unsure if I'm doing something wrong - trying to create a field that links an id from one table into an 'owned_by' column in another. Both a type of int8, and the former field is a primary key. Is this a known issue?

#870692478154571826 has some more details. The functions in the dashboard follow the same format as discussed there.

> Yeah I was showing "how to call a function from the client" and you were asking "how do I create a PostgreSQL function?" But this should become a lot easier for newcomers since our new dashboard piece just came out for this purpose (although it's in Alpha right now).

Dashboard

/

Database

/

Functions

/

Create New Function

.

I've been looking at it, I missed it somehow when looking last night. Thanks for the info there it was super helpful

totally and thank you 🙏 That sounds awesome I'll check it out too

Hi. Regarding row level security, as seen in the Supabase guide, with

name

,

score

, what if I want to restrict insert of

score

and instead a default value is set?

so basically column level security

could anyone help me with this?

You can block all inserts on that table and use a stored function to update only the values you want to give a user access to

So I can't really just block inserting 1 specific column, right?

It's a very long winded process that should be avoided as relational databases don't really work that way.

Hey folks! Has anyone seen any issues with auth endpoints returning 500 errors? I created a database back in December (so it's a bit older), and just came back to hack on the project a bit, but when I call

supabase.auth.signUp(data)

get a 500 error - I see it calling (https://{{myID}}.supabase.co/auth/v1/signup) in the network request

Yeah I'm also seeing 500 errors deleting accounts.

Yah I'm seeing this issue in the response:

{"code":500,"msg":"Database error finding user","error_id":"945062e2-66c1-4e1b-8dfb-fe06e26efb19"}

Just upgraded to the latest JS sdk too

"@supabase/supabase-js": "^1.21.0",

but nada