Multi-Tenant SaaS Web & REST API Authorization Boundary Assessment
1. Client Challenge
Organizations operating multi-tenant web applications and supporting REST APIs frequently pass automated vulnerability scans while harboring deep authorization and parameter-handling flaws across tenant boundaries and legacy administrative endpoints.
2. Assessment Scope
- •Authenticated and unauthenticated web application workflows across 3 privilege tiers (Standard User, Tenant Admin, System Operator)
- •RESTful JSON and form-encoded backend endpoints handling customer records and financial reporting
- •Database query parameterization and session token lifecycle verification
3. Testing Methodology
- ›Attack surface mapping and role-matrix differential analysis across all privilege levels
- ›Manual parameter fuzzing and SQL/NoSQL syntax state analysis informed by real-world CVE research (e.g., CWE-89 patterns observed in CVE-2022-27927, CVE-2022-28079, and CVE-2022-28080)
- ›Horizontal and vertical Broken Object Level Authorization (BOLA / IDOR) testing across resource identifiers and date/filter parameters
4. Illustrative Findings Summary
Unauthenticated / Parameter-Based SQL Injection in Record Update & Reporting Endpoints
Insufficient parameterization in backend record-lookup and date-filtering parameters (`customer_number`, `course_code`, `todate` patterns) allowing direct manipulation of backend SQL statements.
Cross-Tenant Broken Object Level Authorization (BOLA) on Export API
Sequential object identifiers accepted by reporting endpoints without verifying whether the authenticated session's tenant ID owns the requested record.
Permissive Session Token Invalidation on Privilege Change
Existing bearer tokens remained valid after administrative role revocation until natural TTL expiration.
5. Business Impact & 6. Remediation Approach
Demonstrates how a single unparameterized endpoint or missing tenant-ownership check can expose the entire backend database or allow cross-customer data leakage—risks that automated DAST tools often miss when hidden behind multi-step workflows.
- Refactor all dynamic SQL queries to strict prepared statements with bound parameters (`PDO` / parameterized ORM queries).
- Enforce centralized, middleware-level tenant ownership assertions on every object-level API query.
- Bind session validity to server-side role-version claims and execute targeted regression retesting.
7. Deliverable Outcome
Provides engineering leadership with reproducible HTTP requests, exact code-level remediation patterns, and a clean post-remediation verification record suitable for enterprise security due diligence.