Org Structure RLS Policy
Component Detail
Infrastructure
medium complexity
backend
0
Dependencies
0
Dependents
4
Entities
0
Integrations
Description
Supabase Row Level Security policies that restrict write access on org hierarchy tables to admin-level users only, while allowing read access based on organizational membership. Prevents unauthorized modification of the hierarchical structure.
org-rls-policy
Responsibilities
- Enforce admin-only write access on hierarchy tables
- Allow scoped read access based on user org membership
- Prevent non-admin roles from creating or deleting org units
Interfaces
applyAdminWritePolicy(table)
applyScopedReadPolicy(table, userRole)
validatePolicyConfiguration()
Related Data Entities (4)
Data entities managed by this component