Skip to main content

← Identity & Access · Pictures · Spec · Plan

1Principles

The owner can't get in.

  • Auth succeeds but authorization fails — two different systems, two different failure modes
  • PostgreSQL 22P02: query passes Clerk userId where UUID expected
  • The bug is in the query, not the data — even with correct roles, the query crashes
  • Default-deny is right, but only after roles exist to assign
ProblemQuestionDecision
Owner locked out of own appFix the guard or fix the query?Fix the query — 22P02 uses wrong ID type
The Vision
Platform owner staring at a locked dashboard — the guard meant to protect strangers is blocking the builder
1 / 5

Context

  • PRD Index — Identity & Access
  • Pictures — Pre-flight maps
  • Spec — Engineering depth
  • Plan — Implementation coordinates