Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Permissions: Row Level Security (RLS) for viewing specific rows

Topic Labels: Base design Collaboration
93 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Tableau_Guy
4 - Data Explorer
4 - Data Explorer

Hello, 

I'm new to Airtable and already very impressed. My question:

One thing that Databases, PowerBI or Tableau have is RLS (row level security). 

I read this article https://support.airtable.com/docs/permissions-overview but it was more about the capabilities of different roles. What I want is sth different:

In short, let's say I have a column USERNAME in my table. I share my table with a collaborator called Julia. Julia can only see the rows where the column equals to USERNAME is "Julia". It's basically like a filter but the the collaborator cannot unfilter it. Julia would have only viewing / editing access to the above mentioned rows.

RLS are handy as they can scale. In our case, I might have 20 collaborators in the end. All collaborators should only be able to see their "own" rows.

Thank you so much BR!

2 Replies 2

I don't think such functionality exists I'm afraid.  Perhaps you could get around it with an Interface that only displays and allows them to edit records that match the criteria?  Not entirely sure that's possible

You'd end up having to manually create one interface per collaborator though I think

If you're alright with third party things, I think StackerHQ might work for your situation

Thank you so much, will look into StackerHQ. Hopefully someday, RLS is going to be integrated.