RLS
I am working on an ecommerce website and I am having trouble with RLS. I have enabled RLS on an order_item table with the following columns: id,created_at, quantity, order_id & profile_id.
The profile_id column maps to the user's id from the auth table.
I have enabled read access based on the following statement: auth.uid() = profile_id however when I query the order_item table with the right user I am still getting an empty array.
I am using NextJS
The profile_id column maps to the user's id from the auth table.
I have enabled read access based on the following statement: auth.uid() = profile_id however when I query the order_item table with the right user I am still getting an empty array.
I am using NextJS
