Supabase RLS not allowing me Fetch data

[alka7ex]

Hi Guys

Recently I just started to learn sveltekit + supabase, and so far it is good experience.
But now i'm facing a problem where when i enable the RLS, it's not allowing me to fetch the data.

previously i was at impression that this is the problem with my RLS, but it turned out when i try it in my refine.dev apps, its working perfectly, so i think this is the problem with how i fetch the data from my sveltekit apps.

is there anyone can help tell me where im doing wrong?

+hooks.server.ts

import { PUBLIC_SUPABASE_URL, PUBLIC_SUPABASE_ANON_KEY } from '$env/static/public';
import { createServerClient } from '@supabase/ssr';
import { redirect, type Handle } from '@sveltejs/kit';
import { sequence } from '@sveltejs/kit/hooks';

const createSupabaseClient: Handle = async ({ event, resolve }) => {

    event.locals.supabase = createServerClient(PUBLIC_SUPABASE_URL, PUBLIC_SUPABASE_ANON_KEY, {
        cookies: {
            get: (key) => event.cookies.get(key),
            // NOTE: defaulting path to '/' here to support Sveltekit v2 which requires it to be
            // specified.
            set: (key, value, options) => {
                event.cookies.set(key, value, { path: '/', ...options });
            },
            remove: (key, options) => {
                event.cookies.delete(key, { path: '/', ...options });
            }
        }
    });

    /**
     * a little helper that is written for convenience so that instead
     * of calling `const { data: { session } } = await supabase.auth.getSession()`
     * you just call this `await getSession()`
     */
    event.locals.getSession = async () => {
        const {
            data: { session }
        } = await event.locals.supabase.auth.getSession();
        return session;
    };

    if (event.route.id?.startsWith('/(auth)')) {
        if (!(await event.locals.getSession()))
        throw redirect(302, '/login');
    }

    return resolve(event, {
        filterSerializedResponseHeaders(name) {
            // supabase needs the content-range header
            return name === 'content-range';
        }
    });

};

export const handle = sequence(createSupabaseClient);

supabaseclient.ts

import { createClient } from '@supabase/supabase-js';
import { PUBLIC_SUPABASE_URL,PUBLIC_SUPABASE_ANON_KEY } from '$env/static/public';

export const supabaseClient = createClient(PUBLIC_SUPABASE_URL, PUBLIC_SUPABASE_ANON_KEY,{
    db: {
        schema: "public",
      },
      auth: {
        persistSession: true,
      },
})

+page.ts

import type { PageLoad } from './$types';

import { supabaseClient } from '$lib/supabaseClient';

const pageSize = 10;
const pageNumber = 1;

// Calculate the offset based on the page size and page number
const offset = (pageNumber - 1) * pageSize;

export const load = (async () => {
    return await supabaseClient
    .from("profiles")
    .select("*")
    .range(offset, offset + pageSize - 1)
    .limit(pageSize);
}) satisfies PageLoad;