AUTH-012critical SeverityBroken Authentication & Access Controls
Multi-Tenant Data Isolation Enforced in Database Queries
In multi-tenant or team apps, AI forgets to include org_id or team_id in sub-entity queries.
1-Click Fix Prompt for Cursor & Claude Code
Review my codebase for "Multi-Tenant Data Isolation Enforced in Database Queries" (AUTH-012). Issue: In multi-tenant or team apps, AI forgets to include org_id or team_id in sub-entity queries. Remediation required: Include tenant or organization ID in every query filter and test cross-tenant access rejection explicitly. Please: 1. Locate any occurrences of this issue across my repository. 2. Refactor the code to follow production standards without breaking existing functionality. 3. Provide a clear command or step to test and verify the fix.
Why AI Assistants Write This Bug
In multi-tenant or team apps, AI forgets to include org_id or team_id in sub-entity queries.
AI code generation prioritizes immediate syntax execution over production edge cases. When an assistant hits an undefined variable or strict type error, it frequently takes the path of least resistance rather than implementing standard pre-launch security patterns.
Code Comparison
Common AI Code PatternVulnerable
// Vulnerable AI-generated pattern for: Multi-Tenant Data Isolation Enforced in Database Queries
// Insecure route handler trusting body user ID (IDOR risk)
export async function POST(req: Request) {
const { userId, newEmail } = await req.json();
// BUG: Any user can modify any other user record!
await db.user.update({ where: { id: userId }, data: { email: newEmail } });
return Response.json({ success: true });
}Launch-Ready Fix
// Production-ready fix for: Multi-Tenant Data Isolation Enforced in Database Queries
// Protected route deriving identity from verified session
export async function POST(req: Request) {
const session = await auth();
if (!session?.user?.id) {
return Response.json({ error: "Unauthorized" }, { status: 401 });
}
const { newEmail } = await req.json();
// Scoped strictly to authenticated session user ID
await db.user.update({ where: { id: session.user.id }, data: { email: newEmail } });
return Response.json({ success: true });
}Remediation & Verification Checklist
Remediation: Include tenant or organization ID in every query filter and test cross-tenant access rejection explicitly.
- Search your codebase for pattern matching "Multi-Tenant Data Isolation Enforced in Database Queries".
- Apply the recommended remediation: Include tenant or organization ID in every query filter and test cross-tenant access rejection explicitly.
- Run local build and test commands to ensure no regressions.
- Verify in your browser or with curl that the issue is resolved.
Audit All 108 Checks in One Click
Checking items one by one takes hours. Let us do it in 2 minutes.
With the Founder Pass ($15 one-time), we automatically scan your repository for this issue, plus all other 107 launch checks across secrets, Stripe webhooks, Supabase RLS, and security headers.