Skip to main content

​
Overview

Table permissions define what actions users can perform on a table and its records. ERPLite provides four default permission sets and allows you to create custom ones.

​
Default Permission Sets

​
Creator

Full administrative access - cannot be modified.
ActionAllowed
View tableYes
View recordsYes
Create recordsYes
Edit recordsYes
Delete recordsYes
Delete tableYes
Duplicate tableYes
Rename tableYes
Manage columnsYes
Manage viewsYes
Manage automationsYes
Design layoutYes
Share tableYes
Add commentsYes

​
Editor

Can create and modify data, but cannot manage table structure.
ActionAllowed
View tableYes
View recordsYes
Create recordsYes
Edit recordsYes
Delete recordsYes
Manage viewsLimited
Add commentsYes
Other managementNo

​
Commenter

View-only with commenting ability.
ActionAllowed
View tableYes
View recordsYes
Add commentsYes
Create/Edit/DeleteNo

​
Viewer

Pure read-only access.
ActionAllowed
View tableYes
View recordsYes
All other actionsNo

​
Managing Permissions

1

Open Share

Click the Share button on your table
2

Go to Manage Access

Click Manage Access tab
3

Select Permissions Tab

Click Permissions to view and manage permission sets

​
Creating Custom Permissions

1

Open Permissions Tab

Navigate to Share > Manage Access > Permissions
2

Click Add New

Click the Add New button
3

Name Your Permission

Enter a unique, descriptive name (e.g., “Data Entry”, “Auditor”)
4

Select Actions

Check the boxes for each action you want to allow
5

Save

Click Save to create the permission set

​
Available Permissions

PermissionKeyDescription
View tableview_tableSee table in table list
View recordsview_recordOpen and read record details
Create recordscreate_recordAdd new records
Edit recordsedit_recordModify existing records
Delete recordsdelete_recordRemove records
Delete tabledelete_tablePermanently delete table
Duplicate tableduplicate_tableCreate a copy
Rename tablerename_tableChange display name
Manage columnsmanage_table_columnAdd/edit/delete columns
Manage viewsmanage_table_viewCreate/edit views
Manage automationsmanage_table_automationConfigure automations
Design layoutmanage_sectionEdit record layout
Share tableupdate_table_aclManage sharing settings
Add commentsadd_commentComment on records

​
Permission Dependencies

Some permissions require other permissions to work:
PermissionRequires
Delete recordsView records
Edit recordsView records
Create recordsView records
Manage columnsView table
Manage viewsView table
Share tableView table
Add commentsView records
When you select a permission, its dependencies are automatically enabled and cannot be unchecked.

​
Common Permission Patterns

For users who only input data:
  • View table: Yes
  • View records: Yes
  • Create records: Yes
  • Edit records: Yes (own records only via row-level)
  • Delete records: No
  • All management: No
For team leads who need to review and approve:
  • View table: Yes
  • View records: Yes
  • Create records: Yes
  • Edit records: Yes
  • Delete records: Yes
  • Manage views: Yes
  • Add comments: Yes
  • Table management: No
For compliance review:
  • View table: Yes
  • View records: Yes
  • Add comments: Yes
  • All other: No

​
For AI Agents

​
Permission Constants

const TablePermissionsList = [
  'view_table',
  'view_record',
  'create_record',
  'edit_record',
  'delete_record',
  'delete_table',
  'duplicate_table',
  'rename_table',
  'manage_table_column',
  'manage_table_view',
  'manage_table_automation',
  'manage_section',
  'update_table_acl',
  'add_comment'
];

​
Check User Permissions

Use the access control API to verify permissions before operations: 
GET /zorp-tables-service/table/:tableType/table-acl
Authorization: Bearer {secretKey}

​
Create Permission Set via API

PUT /zorp-tables-service/table/table-acl
Authorization: Bearer {secretKey}
Content-Type: application/json

{
  "tableType": "my_table",
  "permissions": [
    {
      "permissionSetName": "Custom Set",
      "permissions": {
        "view_table": true,
        "view_record": true,
        "create_record": true,
        "edit_record": false,
        "delete_record": false,
        "delete_table": false,
        "duplicate_table": false,
        "rename_table": false,
        "manage_table_column": false,
        "manage_table_view": false,
        "manage_table_automation": false,
        "manage_section": false,
        "update_table_acl": false,
        "add_comment": true
      },
      "or": {
        "userIds": [],
        "teamIds": ["team_id"],
        "roleIds": []
      }
    }
  ]
}