Supabase delete does not work

const { error } = await supabase
        .from("auth_user")
        .delete()
        .eq("id", user.id);

    if (error) {
        console.error("[ERROR][PROFILE][DELETE] Failed to delete auth user:", error.message);
        throw new Error("Failed to delete user: " + error.message);
    }

CREATE POLICY "User can see their own profile only" 
ON public.auth_user
FOR SELECT
TO authenticated
USING ((SELECT auth.uid()) = id);