Skip to content

Roles and permissions ​

EquipQR has two role layers: organization roles (Owner, Admin, Member) and team roles (Manager, Technician, Requestor, Viewer). For who should hold each role, see Teams & Roles in the Help Center.

Permission matrix ​

Organization management ​

ActionOwnerAdminMemberManagerTechnicianRequestorViewer
Create Organization✅❌❌❌❌❌❌
Update Organization Settings✅✅❌❌❌❌❌
Delete Organization✅❌❌❌❌❌❌
View Organization Details✅✅✅✅✅✅✅
Switch Organizations✅✅✅✅✅✅✅

Billing capabilities were removed from EquipQR in Jan 2025; there is no billing surface to permission against. Historical billing tables (billing_events, organization_subscriptions, etc.) are kept for auditability only and are not exposed in the UI.

Member management ​

ActionOwnerAdminMemberManagerTechnicianRequestorViewer
Invite Members✅✅❌❌❌❌❌
Remove Members✅✅❌❌❌❌❌
Change Member Roles✅✅*❌❌❌❌❌
View Member List✅✅✅✅✅✅✅
Resend Invitations✅✅❌❌❌❌❌

*Admin cannot change owner role or promote to owner

Team management ​

ActionOwnerAdminMemberManagerTechnicianRequestorViewer
Create Teams✅✅❌❌❌❌❌
Delete Teams✅✅❌✅**❌❌❌
Update Team Settings✅✅❌✅**❌❌❌
Add Team Members✅✅❌✅**❌❌❌
Remove Team Members✅✅❌✅**❌❌❌
View Teams✅✅✅✅✅✅✅
Assign Work Orders✅✅❌✅**❌❌❌

Only for teams where user has Manager role

Equipment management ​

ActionOwnerAdminMemberManagerTechnicianRequestorViewer
Create Equipment✅✅❌✅†✅†❌❌
Update Equipment✅✅❌✅✅‡❌❌
Delete Equipment✅✅❌✅❌❌❌
View Equipment✅✅✅✅✅✅✅
Generate QR Codes✅✅❌✅✅❌❌
Scan QR Codes✅✅✅✅✅✅✅
Update Custom Attributes✅✅❌✅✅‡❌❌

† Org-wide for owners/admins; team-scoped (manager or technician role on the assigned team) for team members. Equipment created without a team assignment is restricted to owners/admins (issue #650).

‡ Limited to status updates and maintenance records

Work order management ​

ActionOwnerAdminMemberManagerTechnicianRequestorViewer
Create Work Orders✅✅✅✅✅✅❌
Update Work Order Status✅✅❌✅✅****❌❌
Assign Work Orders✅✅❌✅❌❌❌
Delete Work Orders✅✅❌✅❌❌❌
View Work Orders✅✅✅*****✅✅*****✅*****✅*****
Complete Work Orders✅✅❌✅✅****❌❌
Cancel Work Orders✅✅❌✅❌❌❌
Reopen Work Order (completed/cancelled)✅✅❌❌❌❌❌
Revert PM✅✅❌❌❌❌❌

****Only assigned work orders *****Limited to relevant work orders (assigned, created by user, or team-related)

Admin revert notes. Revert PM (completed PM checklist) and Reopen work order (completed/cancelled work order) are org owner/admin only (is_org_admin). On a completed work order with a completed PM, Revert PM also reopens the work order to accepted in the same action so the checklist becomes editable again. Reopen work order remains available for work-order-only reopen without changing the PM.

Inventory and internal costing visibility ​

Inventory/parts access is granted through two explicit grants (not organization_members.role values): Parts Manager and Parts Consumer. Owners and admins get access by default. Work order cost line items (parts, unit pricing, labor hours/rates) are internal data: customer-facing roles (team Requestor and Viewer) and plain members must see zero evidence of parts, stock levels, pricing, or labor anywhere in the application. Internal costing and final pricing are handled later in the QuickBooks invoicing phase.

Data / ActionOwnerAdminParts ManagerParts ConsumerManager*Technician*RequestorViewerPlain Member
View inventory, part lookup, alternates✅✅✅✅❌❌❌❌❌
Manage inventory (create/edit/adjust)✅✅✅❌❌❌❌❌❌
Equipment "Parts" tab✅✅✅✅❌❌❌❌❌
Consume parts on work orders ("Add from Inventory")✅✅✅✅†❌❌❌❌❌
View work order cost line items (parts, pricing, labor)✅✅❌‡❌‡✅✅❌❌❌
Cost subtotals on work order cards / dashboard cost widgets✅✅❌‡❌‡✅✅❌❌❌
Labor hours on work order notes / estimated hours✅✅❌‡❌‡✅✅❌❌❌

* Team-level roles on the work order's team. Manager/Technician here refer to team roles, not inventory grants. A work order's team is always its equipment's team (equipment.team_id); work orders have no team column of their own.

† Parts Consumers can consume/restore inventory only through work orders they hold operational cost access to (team owner/manager/technician on the work order's team, or work order assignee). The adjust_inventory_quantity RPC enforces this server-side.

‡ Unless the same user also holds an operational team role (or org owner/admin). Inventory grants never expand work order cost visibility on their own.

Enforcement layers:

  • RLS. work_order_costs policies use can_access_work_order_costs(work_order_id, user_id). That includes org owner/admin, work order assignee, or team owner/manager/technician on the work order's team. Inventory tables use can_access_inventory / can_manage_inventory.
  • Application. useCanViewWorkOrderCosts() gates every cost-surfacing UI (costs section, card subtotals, cost dashboard widgets, labor hours on notes). useInventoryAccess() gates every inventory surface (routes, sidebar, equipment Parts tab, work order part picker, dashboard FAB).
  • Exports. Customer-safe Service Report PDF never includes costs/labor for non-admin audiences. Bulk exports are org-admin only (edge verifyOrgAdmin).

Both grants are managed from the Parts Access panel on the Inventory page (or per member on Organization → Members). Only owners/admins can grant or revoke either role.

List metadata: get_inventory_list_metadata returns health-summary aggregates in one bounded SQL query. There is no backfill on rollout — plain active members are denied until explicitly granted Parts Consumer or Parts Manager. Route guards and nav must hide direct URLs, not just sidebar links.

Part storage locations: org inventory_default_location_* fields plus per-item structured geo in inventoryLocationUtils.ts (part overrides org default; part QR scans do not capture storage location). Customer steps: inventory storage locations.

Audit log visibility (#1122) ​

The organization audit log is restricted to owners and admins at every layer: the page lives under Organization → Audit Log with an in-page role guard, audit_log SELECT RLS requires an active owner/admin membership, and the get_audit_log_timeline RPC re-checks is_org_admin. Audit entries never appear on operational pages (work order or inventory detail) and are never included in data exports outside the dedicated audit CSV/JSON export path, which notifies admins on every export.

EquipQR Support access ​

There is no platform-wide admin. EquipQR staff ("operators", listed by user ID in the DFY_OPERATOR_USER_IDS Edge secret) can reach a customer's data only through a time-limited grant from that organization's owner:

  • The owner grants it from Organization settings → EquipQR Support access (24 hours, 72 hours, or 7 days; 72 hours by default) or by ticking the checkbox in Report an Issue (72 hours). Granting again while access is live extends the grant to the later of the current or newly requested expiry. The owner can revoke at any time from the settings card or the banner that every member sees while access is live.
  • Each operator gets an organization_members row with role = 'admin', status = 'support', access_source = 'support', and support_grant_id. Support rows don't count toward member_count, billing, or Google Workspace reconciliation, because all of those key on status = 'active' or access_source.
  • Expiry is checked when access is checked: every helper that accepts support calls support_grant_is_live(), and a restrictive RLS policy hides expired support rows from direct queries. An hourly cleanup_expired_support_access job only removes rows whose access has already ended.
  • Support rows can be written only by grant_support_access (a guard trigger blocks every other insert or update), so neither an admin nor the operator can make access permanent. When DFY_OPERATOR_USER_IDS is reduced or cleared by deployment configuration sync, reconcile_support_operators immediately removes offboarded operators' live support rows across all organizations and closes any grant with no remaining operators.
PathAccepts live support?
is_org_member, is_org_operational_admin, is_organization_member, user_is_org_member, check_org_access_secure, check_org_access_direct, get_user_organizations, get_user_org_role_secure, get_user_org_role_direct, get_user_organization_membership, can_access_inventory, can_manage_inventory (and operational RLS policies and RPCs opted into them: equipment, work orders, PM, teams, team_members SELECT, inventory, notes, customers, scans, storage)Yes, until expiry
is_org_admin, is_organization_admin, user_is_org_admin (member insert/update/delete), team_members writes (team_members_admin_insert, team_members_admin_update, team_members_admin_delete), organization settings/billing updates (orgs_update_admins), public QR bearer token secrets and management (operator_checkin_token_secrets, quick_form_token_secrets, create_operator_checkin_assignment, rotate_operator_checkin_token, create_quick_form, rotate_quick_form_token), organization_invitations (guard trigger), revoke_provisioned_member (pending staff), get_audit_log_timeline (audit log RPC), bulk export RPCs (enqueue_export_job, export_equipment_csv_rows, export_work_orders_csv_rows), ownership transfer, org deletion, can_user_manage_quickbooks, QuickBooks and Google Workspace credentials, audit log, DSR, and RLS policies that query organization_members directly with status = 'active'No
Edge Function membership helpers (requireOrgMembership, requireOrgAdmin, verifyOrgMembership, verifyOrgAdmin, qbo-work-order-gate)No, they test status = 'active'
Client organization list (sessionDataService, SimpleOrganizationProvider)Yes. It reads status in ('active', 'support'), and RLS hides expired rows

DSR cockpit permissions (Phase one) ​

Route and action policy ​

CapabilityOwnerAdminMember
View DSR queue (/dashboard/dsr)✅✅❌
Open DSR case (/dashboard/dsr/:requestId)✅✅❌
Apply lifecycle actions (verify, deny, extend, complete)✅✅❌
Trigger evidence export (request_export, retry_export)✅✅❌
Resend consumer notices (resend_notice)✅✅❌

Tenant isolation rules ​

  • DSR cases are scoped by dsr_requests.organization_id.
  • Access checks are enforced at both edge-function and database-policy boundaries.
  • Requests outside actor org are returned as 404 (masked cross-org semantics).
  • Role denial inside the same org is returned as 403.

Explicit defaults ​

  • Members are denied by default in phase one.
  • No non-admin operator role is enabled in this release.
  • Any future role expansion must update this document and corresponding RLS + edge-function checks in the same PR.

EquipQR Docs — product app at equipqr.app · status at status.equipqr.app