'User can select their own records' policy not working
Hi everyone!
I am following up this guide on NextJS & Supabase: https://egghead.io/courses/build-a-saas-product-with-next-js-supabase-and-stripe-61f2bc20
I have two tables: Profile(id=uuid) & Document(owner_id = link to Profile (uuid))
I am setting up table access policies as follows:
Profile: User can select their own profile: (uid() = id)
Document: User can select their own documents: (uid() = owner_id)
The Profile table policy works and I can access the data
The Document table policy however returns 0 documents when is enabled
I can't figure out what I am doing wrong, can I get some help please?
Thank you
I am following up this guide on NextJS & Supabase: https://egghead.io/courses/build-a-saas-product-with-next-js-supabase-and-stripe-61f2bc20
I have two tables: Profile(id=uuid) & Document(owner_id = link to Profile (uuid))
I am setting up table access policies as follows:
Profile: User can select their own profile: (uid() = id)
Document: User can select their own documents: (uid() = owner_id)
The Profile table policy works and I can access the data
The Document table policy however returns 0 documents when is enabled
I can't figure out what I am doing wrong, can I get some help please?
Thank you
egghead
Throughout this course, you will learn how to build a static app with authentication that is backed by a database, change the structure of that database without compromising existing data, and take payments for individual products to manage subscriptions.
For your frontend, this application will be using Next.js and Tailwind CSS. You will learn...
For your frontend, this application will be using Next.js and Tailwind CSS. You will learn...
