RLS Policy Manager
Component Detail
Infrastructure
high complexity
Shared Component
backend
1
Dependencies
1
Dependents
3
Entities
1
Integrations
Description
Manages Supabase Row Level Security policies that join through the unit assignment junction table to enforce data access scoping. Generates and applies RLS SQL policies for tables that need unit-level isolation (activities, contacts, reports). Policies are written as Supabase migrations.
rls-policy-manager
Responsibilities
- Define RLS policies for unit-scoped tables
- Inject user unit assignments into JWT claims for RLS evaluation
- Provide SQL migration scripts for policy deployment
- Test RLS policy effectiveness against simulated roles
Interfaces
applyPolicies(tableName)
buildJwtClaims(userId)
generateMigration(policyDefinitions)
testPolicyForUser(userId, resourceId)
listActivePolicies()
Relationships
Related Data Entities (3)
Data entities managed by this component
Used Integrations (1)
External integrations and APIs this component relies on