Menu

1 / 3

OpenSparrow v4.6 adds per-table write permissions and "Last change" diff in the Record History tab

DEV Community: php·Tomasz·5 days ago
#bIFSrJv5
#devto#dev#table#edit#demo
Reading 0:00
15s threshold

Tomasz

Posted on Nov 11

Edited on Nov 11

OpenSparrow v4.6 adds per-table write permissions (create / edit / delete), a "Last change" diff in the Record History tab, and route-bound API authorization — plus click statistics in demo mode.

Per-table write permissions

Users → Access already decided where an account may go (tables, views, boards, workflows). Now it also decides what : on top of the table allow-list, each user entry can carry a perms map that narrows writes per table — {"orders": ["create","edit"], "clients": []} . The tables list stays the read grant; a missing mask keeps full CRUD (no account loses anything on upgrade), an empty mask means read-only, and the full set is never stored — it collapses back to "absent".

The Access tab shows a Create / Edit / Delete checkbox group per ticked table, and the mask is enforced server-side everywhere: grid routes are gated once in the front controller, the create/edit forms render disabled and refuse POSTs, mass edit, find-and-replace and mass…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.