Skip to content

core: implement Supabase Row Level Security for all tables #32

@EmeditWeb

Description

@EmeditWeb

Problem

The Supabase tables have no Row Level Security
policies. Any service role query can read and
modify any row.

What To Build

Write RLS policies for all tables:

  • learner_profiles
  • loans
  • repayment_installments
  • vouches
  • vendors
  • pool_positions

Files To Touch

  • supabase/migrations/[ts]_rls_policies.sql (new)

Acceptance Criteria

  • All tables have RLS enabled
  • Users can only access their own data
  • Public data accessible without auth
  • Admin operations use service role
  • npm run build passes

Mandatory Checks Before PR

  • All RLS policies tested
  • No data leakage between users
  • PR references this issue

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions