Build the safeguards
Eight explained steps, a source example and a checkpoint at each decision.
Read the tutorialAPI security / PostgreSQL RLS / Identity
Compare the choices.
Choose a pattern by the failure it addresses. Several safeguards can be necessary at once.
Which approach fits the problem?
| Approach | Useful when | Decision or limitation |
|---|---|---|
| UI visibility | Make the available actions understandable | Not an authorization boundary |
| Handler policy | Validate identity, membership and action | Every entry point must invoke it |
| Database row policy | Restrict rows under a restricted application role | Owners, privileged roles and connection context need care |
| Role-based permissions | A small stable set of responsibilities | Can become coarse as rules depend on resources |
| Attribute-based policy | Rules depend on ownership or resource state | Requires explicit inputs and understandable audit reasons |
| Opaque server session | A local application owns session state | Needs lifecycle, transport and revocation controls |
Which environment should you use?
| Environment | What you can do | Scope |
|---|---|---|
| This browser lab | Click, compare, reset and inspect exact source | Invented sessions feed actual PostgreSQL row policies in your browser. The download adds a local HTTP adapter with opaque fixture sessions. Neither version is a production identity provider or a test of every database-privilege configuration. |
| Independent download | Run the same prebuilt lab with Python’s local server | No package installation or automatic external calls needed for the prebuilt preview |
| Native exercise | Run language tests and the included local adapter or script | Requires the documented local toolchain; does not provision a cloud service |
A comparison you can reproduce
The safe cross-company read returns 404 with no foreign rows. A viewer’s edit returns 403; an expired session returns 401. A list query without a tenant filter still returns only Orchard’s row under RLS.
What this adds to a conventional tutorial
Begin with an observable outcome, inspect the decisions that produced it, then test a repair. The companion tutorial explains the mechanism; the how-to guide takes the same source into an independent environment.
Read the primary documentation
Mux’s full-stack opening includes identity and account-management product features.
Choose your next step
Compare the alternatives
Understand where each pattern helps and which tradeoffs remain.
Compare approachesRun and extend it locally
Download the independent environment, run the native checks and try a specific extension.
Open the how-to guide