How to add additional data to users

I went back to the dashboard and disabled RLS and also added a public policy to the table but to no avail - throws the error with the error code 42501

Anyone else has issues when creating a bucket? me and @User get network request failed

Storage issue

hey, so, how do I specify the row level security rules using the UI?

RLS with supabase

is it possible to set the return value of

auth.role()

to something else?

Any idea? 😰

How to update jsonb field with supabase

Hey! Can i set triggers on auth.users?

How to trigger on auth.users

I think I found a bug in the api... when I try to sign up using

supabase.auth.signUp

using an email address and password for an account that already exists, I get back a 400 status code, which is expected, but the error message is

Thanks for registering, now check your email to complete the process."

, which is not what I expect it to be. Am I missing something, or is that a bug ?

These have all been answered, you can see one and two in the Supabase docs

👋 hey everybody, quick question regarding the database RLS, is there a way to configure that in the web portal or do I need to write a query to set it up?

Just want to make a table read only (it's just got a large csv file that couldn't be loaded in the app without using a lot of memory)

constantly getting just an endless spinning and getting a network request failed

Creating a bucket is failing with endless spinner

@Nine I would guess that bucket names are globally unique so try a unique name. Total guess tho.

Hey ya'll I'm trying to build vanilla js component that has CRUD functionality by way of a Shopify store front. I don't need to perform any Auth tasks with Supbase as my users will already be logged in via the Shopify front end, I just need to send the user id and the product id to a supabase instance and then query that again from a /wishlist page. Before diving into Supabase for something like this does anybody see any flaws in me doing this? Appreciate any help/insights.

guys, what is the difference between these 2?

Using and Check difference

Hi there just a quick question. If i'm using nextjs. Usually i would be putting my

supabaseClient

at the

_app.js

so every following page can use it right?

Supabase Client location

Hey all, I am wondering how to access auth.uid() from within a stored procedure. Is that possible and if so, how?

hey, I'm running into an issue with permissions I think. I'm trying to insert values into

public.shadow_users

after an insert on

auth.users

, however inserting a new user fails, because apparently the stored procedure that's triggered on

auth.users

does not have permission to write to

public.shadow_users

. Is this something I can fix on my end? is this a bug? Is this something that's working as intended and won't be fixed?

sql
create table users (
    id uuid references auth.users on delete cascade,
    email text unique not null,
    name text
);

create or replace function shadow_users()
  returns trigger
  language plpgsql
  as
  $$
  begin
    insert into public.users (id, email) values (new.id, new.email);
    return new;
  end;
  $$;


CREATE TRIGGER shadow_users_trigger
    AFTER INSERT ON auth.users
    FOR EACH ROW
    EXECUTE FUNCTION shadow_users();

Trigger not working

@User can we ban this>

Thanks for the heads up, I've banned that account now.

I have a question regarding authentification with supabase goTrue. I need to support a third party provider which offers oAuth2 and OpenID connect. Unfortunately it is not yet directly supported by supabase. What do I need to do to integrate an unsupported auth provider in my supabase project? Firebase does support a general oAuth2 authentication flow but I would prefer not to go back to Firebase. Related github issue (not by me): https://github.com/supabase/gotrue/issues/159