Back to blog
sensitive dataRLSuser portal

User portal and RLS: what really breaks separation

Published on 2026-04-165 min readCleanIssue

> TL;DR: Even with RLS enabled, an employee portal can still expose too much if the business rules behind it stay incomplete.

Enabled RLS does not mean correct separation

In an employee portal, failures usually come from weak perimeter modeling: company scope, manager role, employee history, or shared document logic.

For more — see our AI agent security review.

What needs testing

Can an employee see anything outside their own area? Can a manager cross a boundary? Can a document be retrieved outside the intended path?

For software vendors

CleanIssue specializes in security reviews for software handling sensitive data. If you're building a product, payroll tool, or ATS and want an external review of your exposure before a client audit or security questionnaire, see our offer for software vendors.

Key Takeaways

  • Test every RLS policy with different role tokens — a single missing SELECT policy exposes all data.
  • Storage buckets need their own policies, separate from table RLS.
  • Automate tenant isolation tests in CI/CD before every deployment.
  • Building software? CleanIssue performs security audits for your product in real-world conditions, no source code access needed. For a first read of your exposure, start with an external review of your application.

    Sources

    Written by CleanIssue
    Reviewed on 2026-04-16

    Editorial analysis based on official vendor, project, and regulator documentation.

    Related services

    If this topic maps to a real risk in your stack, these are the most relevant CleanIssue audits.

    Want to know what your AI agent can do?

    Tell us about your agent, its tools, and client context. We will come back with the right review scope.

    Discuss your audit