Skip to content
env-sync-viewer
Menu

Feature

Least privilege in the database

The collector role can only insert and the viewer role can only select, with row-level security forced on every table.

Two roles own all access: collector gets INSERT and viewer gets SELECT on the three tables. Each app logs in with its own login role that inherits one of them.

Row-level security is forced on every table, and the default public, anonymous, authenticated and service roles are revoked from the schema.

Neither app can update or delete a row, so history cannot be rewritten through them.