Learn how to integrate Auth0 authentication with database storage and row-level security authorization in Supabase.
Read more…
Brought to you by our guest author Jon Meyers
Learn how to integrate Auth0 authentication with database storage and row-level security authorization in Supabase.
Read more…
Brought to you by our guest author Jon Meyers
What’s up Devs! Please share any comments or feedback with us on this thread
Jon,
Thanks for this great article! One Typescript question:
export const getSupabase = (access_token?: any) => {
const supabaseClient = createClient(
process.env.NEXT_PUBLIC_SUPABASE_URL,
process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY
);
if (access_token) {
// Typescript error here
supabaseClient.auth.session = () => ({
access_token,
});
}
return supabaseClient;
}
I’m getting the following Typescript error:
Type '{ access_token: any; }' is missing the following properties from type 'Session': token_type, userts(2739)
Hey there @juanzgc!
Feel free to DM @dijonmusters about that through his Twitter profile that he provided
@dijonmusters this guide is now outdated based on the row level security updates in this release. I just spent a day trying to figure out why the RLS wouldn’t work . Could you update the documentation here?
For anyone else who finds this, you need to replace
create or replace function auth.user_id() returns text as $$
select nullif(current_setting('request.jwt.claim.userId', true), '')::text;
$$ language sql stable;
with
create or replace function auth.user_id()
returns text
language sql stable
as $$
select (current_setting('request.jwt.claims', true)::jsonb ->> 'userId')::text
$$;
Thanks a lot for sharing that with the rest of community!
This topic was automatically closed after 29 days. New replies are no longer allowed.