Row-Level Security for Sales Team Data - Workaround or Alternative Solutions?

Discord-Discussions
1

Hi NocoDB community,

I’m evaluating NocoDB for a sales management use case and need help understanding the best approach for data access control.

My Requirements

  1. Single Master Table: One main sales table containing all sales records from multiple sales people
  2. Row-Level Access Control: Each salesperson should only be able to view and edit their own records
  3. Data Sync: If I need to split into multiple tables, changes in smaller tables must automatically sync back to the master table

What I’ve Learned So Far

From the documentation, I understand that:

  • NocoDB supports Table-level and Field-level permissions (Team plan+)
  • Shared Views are read-only
  • Permissions “cannot be defined for individual records or specific subsets”

My Questions

  1. Is there a recommended workaround for achieving row-level access control in NocoDB today?

Use Case Context

  • Self-hosted deployment
  • ~10-20 sales people
  • Each managing 1000+ records
  • Need audit trail and data integrity

Any guidance would be much appreciated! Thanks in advance.

2

@Chloe Welcome to NocoDB community.

NocoDB doesn’t support Row-Level Security currently, but it is in our roadmap. Please get in touch with cs@nocodb.com to discuss more OR book a call at https://cal.com/nocodb/sales