Security Architecture Builder

Live RLS from Base44 + recommended rules from Role Matrix

Live data from 1:47:54 PM — click Refresh to update

How "Live RLS" is determined: This page reads RLS from the Base44 SDK by calling entity.schema() for each entity and using schema.rls. RLS is enforced on the Base44 backend (server-side); the app cannot bypass it. The SDK may not expose RLS in the schema response, so "Live" can show "No RLS" even when the backend does enforce rules. Use "Refresh live RLS" after changing RLS in the Base44 dashboard; if it still looks wrong, the platform may not return RLS in the schema API.

Security Health
Critical Risk
  • 1 entity/entities missing tenant field "organizationId"
  • Non-admin roles have create permission
Tenant Boundary

Some entities missing "organizationId"

Role Matrix (change rules here)

Toggles apply to all entities. Updates descriptions below.

Rolecreatereadupdatedelete
Admin
User
What the current rules mean for the app

Based on the Role Matrix (recommended). Each entity card shows Live RLS (actual Base44) vs Recommended.

  • Patient journey cards (WorkflowCard)Visible to: Admin, User. caseId links to patient; displayLabel may show initials Card create: Admin, User. Edit/move: Admin, User. Delete: Admin.
  • Team messages (ChatMessage)Messages shown when Admin or User can read ChatMessage. Sending allowed for: Admin, User. Workstation list (Workstation) visible when Read allowed.
  • Boards & columns (WorkflowBoard)Boards visible: Admin, User. Create board: Admin, User.
  • Alerts (Alert)Alerts visible: Admin, User. Create/update: Admin, User.
  • Files & attachmentsStored via S3; card attachments are references on WorkflowCard. Who sees cards (above) controls who can open card detail and thus attachment links.
  • PHI exposureWorkflowCard (caseId, displayLabel), ChatMessage (content), Alert/CardActivity metadata may contain PHI. Read access to these entities = who can see that data. Current read: Admin, User.

All 13 entities — current rules and app impact

WorkflowCard
orgId
created_by
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Patient journey cards on boards
PHI: caseId links to patient; displayLabel may show initials

Read = see cards. Create = add card. Update = edit/move. Delete = remove card.

WorkflowBoard
orgId
created_by
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Boards (e.g. Patient Journey, Lab Work)
PHI: Board names and column config only; PHI is on cards.

Read = see boards. Create = new board. Update = rename/reorder. Delete = remove board.

ChatMessage
orgId
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Team chat messages
PHI: Message content may mention patients or procedures.

Read = see messages. Create = send. Update = edit (if supported). Delete = clear/remove.

Alert
orgId
created_by
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: In-app alerts/notifications
PHI: Alert text could reference cases.

Read = see alerts. Create = raise alert. Update = acknowledge. Delete = dismiss.

CardActivity
orgId
created_by
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Activity log for card changes
PHI: Metadata may reference case/patient.

Read = see activity. Create = log activity. Update/Delete = usually restricted.

Workstation
orgId
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Workstation list and selection
PHI: None.

Read = see workstations and choose one. Create = seed defaults. Update = rename/claim. Delete = reset.

ComplianceDataStore
orgId
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Compliance key-value store
PHI: Depends on keys; may hold references.

Read = see compliance data. Create/Update = write. Delete = purge.

CardColorLabel
orgId
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Card color labels
PHI: None.

Read = see labels. Create/Update = manage labels. Delete = remove label.

BoardRule
orgId
created_by
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Board automation rules
PHI: Rule config only.

Read = see rules. Create/Update/Delete = configure rules.

PracticeProfile
orgId
created_by
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Practice/organisation profile
PHI: Practice name, settings.

Read = see profile. Update = edit (usually admin).

PacDentGame
orgId
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Pac-Man multiplayer game state
PHI: None.

Read = see game. Create = new game. Update = move/inputs. Delete = end game.

AuditEvent
orgId
userId
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Audit log (archive, restore, delete)
PHI: entityId/caseId in metadata.

Read = view audit log. Create = app writes only. Update/Delete = typically denied.

WhackAToothLeaderboard
orgId
userId
Live RLS (Base44): create: — · read: — · update: — · delete: —
Recommended (Role Matrix): Create Admin, User · Read Admin, User · Update Admin, User · Delete Admin
App: Whack-A-Plaque leaderboard
PHI: None.

Read = see scores. Create = submit score.

Security Simulation Tool

Simulate allowed/denied based on current Role Matrix (no live API).

Allowed
RLS Rule Generator

Expand any entity card above and use "Show RLS JSON" to copy create/read/update/delete rules for Base44.

Rules are generated from the tenant field and Role Matrix. Each entity card shows the same pattern; copy the JSON you need from the entity that matches your Base44 entity name.

double-space to open