v2.0.0 is the release in which CYPEX becomes a multi-tenant PostgreSQL
application platform. Tenancy is a first-class object (Organizations),
isolation is enforced in the database (Row-Level Security), authorization
is two-dimensional (Capabilities × Data Scope), schema exposure is explicit
(Schema Access), identity can be federated (SSO Gateway), and outbound
integrations are governed (allowlist, credentials, enablement, audit).
Warning
This is not a drop-in patch. v2.0.0 changes the permission and tenancy model.
Read the Upgrade to v2.0.0
operator guide before planning a maintenance window, then the
Upgrading to v2.0.0
technical reference for the database detail.
RLS, role semantics, Schema Access, new service, route changes
Organizations
A CYPEX deployment can serve more than one tenant — an Organization — from
the same PostgreSQL database. Isolation is enforced by Row-Level Security in
the database, not by UI filtering.
This page is the operational counterpart to the conceptual pages in the
Organizations section. It targets operators who run CYPEX, the PostgreSQL
Application Platform, in production and need to perform the four day-to-day
jobs: create, edit, and disable organizations; give users access to an
organization; configure org-scoped application visibility (Schema Access); and
troubleshoot misconfigurations.
For the why behind the model, see the conceptual pages linked below.
Concepts you need first
Read these four pages before walking through the procedures:
This page is for people who build and ship CYPEX applications. It covers what
changes about that job once a deployment has more than one Organization.
Organization scope on this page is enforced by CYPEX itself, not by the browser.
Hiding a row in the admin panel would be cosmetic; what is described below holds
even for a caller who manipulates the request directly.
Application visibility per organization
The Applications page does
not show every application in the deployment to every admin. A system admin can
pick any organization in the organization filter, or clear it to see everything.
An organization admin is always restricted to their own organization — changing
the filter in the browser does not widen what comes back.
Schema Access decides which PostgreSQL schemas an organization may use. It
is the coarsest of the three access controls in v2.0.0 and it sits above the
other two: an organization that has not been granted a schema sees nothing in
it, regardless of role capabilities and regardless of what the RLS policy would
have allowed.
Sidebar location: Access Control → Advanced (System admin) → Schema Access.
This page is System Administrator only (system admin visibility). An
Organization Administrator cannot grant their own organization a schema — by
design, since doing so would let a tenant widen its own boundary.