How to reset database password

Need Help with Azure AD sign in - Hi, I am able to connect my project to sign in with Azure AD and it works perfectly. However, I wanted to know how can I fetch the token provided by Azure to trigger Microsoft Graph API on user's behalf? Can someone please help?

Hi, Does Supabase have a pre-built UI for authentication?

Error with trigger function on auth.users table.

Auth UI

kong 2.8.x isnt supported?

Hi all, I see Storage Requests in my Dashboard, but don't have anything in storage. Nor do I make any calls explicitly to using

@supabase/storage-js

. I do see this in my package.json. Are these calls implicit somewhere in the supabase client?

supabase.js does not make storage requests unless you make a storage call. Possibly the Studio UI checking for buckets?

Ah that makes sense.

Thank you.

Btw not sure where to report this, but deleting an organization doesn't seem to work. It complains the name doesn't match the Org when deleting but it does typed in.

Double check you are typing in the made up name it provides for confirmation versus the real org name.

@User I've been experimenting some after our previous discussions, and I managed to make a simple/static RLS rule on update (WITH CHECK):

(111 = client_id)

This would allow me to update only if the

client_id

field/part of the new data (i.e. the POST data) was equal to "111". I have not been able to make any functions within Supabase at all, based on the code you suggested and based on the examples in the tutorials. Supabase only gives me syntax errors "near create" etc...

Thanks. I think I am, will check again.

I am trying to update my

profiles

table with content returned in the

user_metadata

hash, which is returned from Supabase on a successful OAuth call. Specifically I am authenticating with Twitter, and would like to save the returned twitter ID and handle, from the user_metadata, in my

profiles

table. I've considered creating an API route, and using a function hook - I followed this approach to create a Stripe user and store the ID, but I am realizing that that only worked since function hooks can access rows directly from profiles in the the

req.body.record

received by the API by default. As far as I can tell function hooks do not have access to the user metadata hash, please correct me if I'm wrong here! Is there any way to do this other than making a client side call right after Oauth? That seems super flaky. Lost here.

I have a table

products

and RLS is set without any policy which means it does not allow any action read, write, delete. Now I have a view which does

select * from products

this view has no RLS. My intention is to let anon key read everything inside products but never modify anything the reason I use view is so I can filter the columns I want to return at db level without needing to change anything in my code. You can create RLS policies manually for views but the Policies section in supabase should show the option to enable RLS in views or functions otherwise people can do UPDATE or DELETE query on a view and modify the data of actual table the view depends on even if the table has RLS enabled. EDIT: 1) Ok I relised RLS cannot be enabled on views. Solution GRANT can be used for this:

REVOKE ALL ON TABLE products_view FROM anon;

GRANT SELECT ON TABLE products_view TO anon;

lmao I'm an idiot,

getServerSideProps

finally clicked

wow next.js is very cool

Is it possible to link additional (social) providers to an existing user/account? Can't seem to find anything in the docs about this.

In the docs it says that using deleteUser requires the service role key. But in the api I can only see that deleteUser expects the uid

Multiple social providers

Hey 🙂 I'm dockerizing my app but now it can't access my local supabase instance (since the supabase instance isn't part of the docker compose network). Am I missing something obvious here? Thanks!

Hi everyone, I restored a project but I can't seem too access the original API and when trying too view the API page on the project dashboard I get a Error: [401] Invalid authentication credentials error. Do I need to give it some time or is something wrong? Thanks in advance

Was someone able to connect Supabase to Google DataStudio?

Api doesn't working suddenly.. Any Idea?

Is it just me or does the not( modifier simply not work

The biggest thing to remember with any negative filter on postgres is null values do not exist. So if you do .not('col','eq','val') it would not return rows with null (and also val).

I have two separate supabase calls

const { data: mutualReviews, error: mutualError } = await supabase
        .from('reviews')
        .select('score, text, profiles!inner(*)')
        .eq('video_id', id)
        .neq('user_id', user.id)
        .in('profiles.twitter_handle', profile.twitter_follows)
        .contains('profiles.twitter_follows', [profile.twitter_handle])

      const { data: followsReviews, error: followsError } = await supabase
        .from('reviews')
        .select('score, text, profiles!inner(*)')
        .eq('video_id', id)
        .neq('user_id', user.id)
        .in('profiles.twitter_handle', profile.twitter_follows)
        .not('profiles.twitter_follows', 'contains', [profile.twitter_handle])

The only differentiating line is the final one, contains vs not. In this context not does not work at all. I think that maybe it only works for 'eq'?

Hi everyone, need some advice how to create/add indexes on the existing table. I created the table some time ago and need to add indexes on columns as the query is getting heavier. I tried to run

create index

command but I got "ERROR: must be owner of table". Also tried to run

create index concurrently

and got the same error. Turns out the "postgres" user is not an owner and "supabase_admin" is the owner. Of course, I don't have access to "supabase_admin" owner user. need some advice how to do this thanks in advance

I have the exact same issue