P0 Audit: 3D Capability Matrix (RBAC) — SQLAlchemy Model Audit #283

New Issue

kincses · 2026-06-24T09:49:07+02:00

kincses commented

2026-06-24 09:49:07 +02:00

Mérföldkő: P0 — Infrastructure & Enterprise Readiness
Cél: Read-only audit of existing SQLAlchemy models to assess readiness for a 3-Dimensional RBAC system (Global Roles × Tenant Roles × Subscription Capabilities).

🔗 Függőségek (Dependencies)

Bemenet (Mikre támaszkodik): backend/app/models/ — User, Organization, OrganizationMember, AssetCostCategory models; PostgreSQL database schema
Kimenet (Mik támaszkodnak rá): All subsequent DB migrations, subscription engine, UI permission gates

📝 Elemzés

We need to audit 4 critical dimensions: (1) Global/System roles on the User model, (2) Local/Tenant roles on the OrganizationMember pivot, (3) Subscription tier + JSONB overrides on Organization, (4) Feature-capability linkage on AssetCostCategory. The result will be a Markdown report proposing exact DB migration steps.

**Mérföldkő:** P0 — Infrastructure \& Enterprise Readiness **Cél:** Read-only audit of existing SQLAlchemy models to assess readiness for a 3-Dimensional RBAC system (Global Roles × Tenant Roles × Subscription Capabilities). ### 🔗 Függőségek (Dependencies) - **Bemenet (Mikre támaszkodik):** backend/app/models/ — User, Organization, OrganizationMember, AssetCostCategory models; PostgreSQL database schema - **Kimenet (Mik támaszkodnak rá):** All subsequent DB migrations, subscription engine, UI permission gates ### 📝 Elemzés We need to audit 4 critical dimensions: (1) Global/System roles on the User model, (2) Local/Tenant roles on the OrganizationMember pivot, (3) Subscription tier + JSONB overrides on Organization, (4) Feature-capability linkage on AssetCostCategory. The result will be a Markdown report proposing exact DB migration steps.

kincses added the Scope: Backend Type: Feature Status: In Progress labels 2026-06-24 09:49:16 +02:00

kincses started working 2026-06-24 09:49:16 +02:00

kincses commented

2026-06-24 09:49:16 +02:00

▶️ Munka megkezdve: 2026-06-24 09:49:16

▶️ **Munka megkezdve:** 2026-06-24 09:49:16

kincses added Status: Done and removed Status: In Progress labels 2026-06-24 09:51:48 +02:00

kincses worked for 2 minutes

2026-06-24 09:51:48 +02:00

kincses closed this issue

2026-06-24 09:51:48 +02:00

kincses commented

2026-06-24 09:51:48 +02:00

✅ Munka befejezve: 2026-06-24 09:51:48

Technikai Összefoglaló:
Completed read-only model audit for 3D Capability Matrix (RBAC). Report saved at docs/p0_3d_capability_matrix_audit_report.md. Key findings: D1 (Global Roles) + D2 (Tenant Roles) are sufficient. D3 needs custom_features JSONB on Organization. D4 needs required_feature column on CostCategory. Proposed 3 ALTER TABLE migrations + 1 optional ENUM.

⏱️ Az idő rögzítve.

✅ **Munka befejezve:** 2026-06-24 09:51:48 **Technikai Összefoglaló:** Completed read-only model audit for 3D Capability Matrix (RBAC). Report saved at docs/p0_3d_capability_matrix_audit_report.md. Key findings: D1 (Global Roles) + D2 (Tenant Roles) are sufficient. D3 needs custom_features JSONB on Organization. D4 needs required_feature column on CostCategory. Proposed 3 ALTER TABLE migrations + 1 optional ENUM. ⏱️ *Az idő rögzítve.*

Sign in to join this conversation.

1 Participants

Notifications

Total Time Spent: 2 minutes

kincses

2 minutes

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: kincses/service-finder#283