Table-Level Access Restrictions

[Makimousse]

Hihi all,
I have an app to manage my PostgreSQL database (on Budibase Cloud), and I would need to limit some of my user's access to specific tables within the database (however they still need to be able to access/modify other tables within the database). Does anybody know how I could do that/if it is possible on Budibase?

[mikesealey]

Hey @Makimousse - it sounds like you need to create Views

Here I've got the Employees table from the sample Budibase DB

But I don't want everyone knowingthe address, city, postcode, and phone-number of my staff.

I'll set the table's access role to Admin...

And then create a view - Employees Public, changing the access to "Public"

Then I'll use the Columns tab to restrict which columns appear in this public view

My View can then be used as a datasource in place of anywhere that you might originally display the base-level table.

[Makimousse]

Thanks a lot! Is it possible that, instead of assigning the view to one of the roles, to assign it to specific users or custom roles?