# Share a database with permissions by table and field | BaseTable

> Invite your team to an online database and decide who edits, who only views, and which columns no one sees. Permissions by table, view, and field—no coding required. Free.

- **Source (source):** https://aistohire.com/basetable-flexible-online-database-154/f/share-database-with-field-level-permissions
- **Platform (platform):** AIstoHire
- **Language (language):** en

## In summary

- Share a base and decide exactly what each person sees
- Table by table, view by view, and field by field: you invite someone to your database and choose whether they can edit, just view, or not even see that column.
- Role by table, not by base
- Field-level permissions
- Hidden data never leaves

## Share a base and decide exactly what each person sees

BaseTable is the no-code database app from AIsToHire, and sharing is built into it, not an add-on. You maintain your own directory of collaborators (up to 100 per account) with name and email, and from any base you choose who to invite and with what scope. The invitation is a single-use link that you generate and copy from the app itself: when that person opens it, they become linked to your directory and the base appears on their home screen, in the "Shared with me" section, with your name as owner.

Permissions are set at three levels. First the table: for each table in the base, that person is Editor, Viewer, or has no access. Then the views: you can give them all the table's views or select only the ones they should see, for example the filtered grid for their region and nothing else, and decide whether they're allowed to adjust filters, sorting, and grouping on their own or if the view stays exactly as you left it. And finally the fields: field by field you choose Edit, View only, or Hidden, with the only rule being that the primary field can never be hidden.

Hidden fields aren't just hidden on screen: the server doesn't send them. A guest receives neither the column definition nor the values it contains, nor the tables they don't have shared. The rest of the app automatically adapts to what that person can do: read-only cells can't be edited, views you haven't given them don't exist for them, and if they're not an editor on any table, the entire base opens in read-only mode.

On your end, you always see who you're sharing with: the base card shows the count of people with access, and when viewing a specific table, view, or field, you know how many of them can reach it. Changing a permission or removing someone from the base is one click, and takes effect as soon as that person refreshes.

## What's included

- **Role by table, not by base** — in the same base, someone can be an editor of Tasks, a viewer of Clients, and not see Billing. Each table is decided separately.
- **Field-level permissions** — column by column you choose if it can be edited, is read-only, or stays hidden. Ideal for salaries, margins, internal notes, or personal data.
- **Hidden data never leaves** — fields marked as hidden and non-shared tables don't leave the server. It's not a visual filter that can be bypassed by inspecting the browser.
- **Visible views of your choice** — give them all table views or just the ones you want, and decide if they can reorder and filter as they like or if the view stays as you configured it.
- **Single-use link invitation** — generate it from the app, send it however you want, and it expires once used. See at all times who's invited and who's already linked.
- **Reusable collaborator directory** — add a person once and share them across all the bases you want, each with different permissions.
- **Sharing counters in plain sight** — the base tells you how many people it's shared with, and each table, view, and field shows how many can access it. No surprises.
- **Removing access is instant** — remove someone from the base or downgrade their role in one click and they lose access. Their data stays in your base, the access doesn't.

## Frequently Asked Questions

### Can I share only one table from my base and not the rest?

Yes. When sharing a base in BaseTable, permissions are set table by table: for each one you choose Editor, Viewer, or No access. Tables you leave without access are not sent to that person, so they don't appear on their screen and they can't reach them through any other means.

### How do I hide a specific column, like salary or margin, from someone who does have access to the table?

In the sharing panel, open the granular permissions for that table and set that field to Hidden. The server will stop sending both the column and its values to that person. The only exception is the table's primary field (the one that names each record), which cannot be hidden because it's what identifies the record.

### Can you give read-only access to some fields and edit access to others?

Yes. Each field supports three values: Edit, View only, and Hidden, plus According to role, which inherits the person's permission on the table. This way you can have someone as an editor of a table but only let them modify two columns, with the rest in read-only mode.

### How do I invite someone to my database?

First, add that person to your collaborators directory with their name and email. Then, in the database, assign them the role you want for each table and generate their invitation link: it's a single-use link that you copy and send however you prefer. When they open it, they become linked and the database appears in their "Shared with me" section.

### Can I remove someone's access or change their permissions later?

At any time. You can increase or decrease their role on a table, change which views they see, adjust field permissions, or remove them from the database entirely. The change takes effect as soon as that person reloads the database, and their records and edits remain in your database.

- [BaseTable — Flexible spreadsheet-style database](https://aistohire.com/basetable-flexible-online-database-154)

## About the platform

**BaseTable — Flexible spreadsheet-style database** — an app by AIstoHire. Available at: https://aistohire.com/basetable-flexible-online-database-154/f/share-database-with-field-level-permissions

### Other languages

- `es`: https://aistohire.com/es/basetable-base-datos-flexible-online-154/f/compartir-base-de-datos-con-permisos-por-campo
- `fr`: https://aistohire.com/fr/basetable-base-de-donnees-flexible-en-ligne-154/f/partager-base-de-donnees-avec-permissions-par-champ
- `it`: https://aistohire.com/it/basetable-database-flessibile-online-154/f/condividere-database-con-permessi-per-campo
- `pt`: https://aistohire.com/pt/basetable-banco-de-dados-flexivel-online-154/f/compartilhar-base-de-dados-com-permissoes-por-campo
- `de`: https://aistohire.com/de/basetable-flexible-online-datenbank-154/f/datenbank-mit-berechtigungen-pro-feld-teilen
- `bg`: https://aistohire.com/bg/basetable-onlayn-baza-danni-kato-elektronna-tablitsa-bez-programirane-154/f/sporedelyane-na-baza-danni-s-prava-po-pole
- `ja`: https://aistohire.com/ja/nokodo-database-spreadsheet-154/f/database-kyoyu-field-tani-kengen
- `nl`: https://aistohire.com/nl/basetable-online-database-als-spreadsheet-zonder-code-154/f/database-delen-met-rechten-per-veld
- `ko`: https://aistohire.com/ko/basetable-nocode-database-spreadsheet-154/f/field-bogeum-gwonhan-database-gongyu
- `sv`: https://aistohire.com/sv/basetable-databas-online-i-kalkylbladsstil-utan-kod-154/f/dela-databas-med-behorigheter-per-falt
- `da`: https://aistohire.com/da/basetable-online-database-som-et-regneark-uden-kode-154/f/del-database-med-rettigheder-pr-felt
- `ar`: https://aistohire.com/ar/basetable-qaada-bianat-aunlain-shbiha-bjdul-albianat-dun-brmja-154/f/share-database-with-field-permissions
- `no`: https://aistohire.com/no/basetable-database-pa-nett-i-regnearkstil-uten-koding-154/f/dele-database-med-tillatelser-per-felt
- `fi`: https://aistohire.com/fi/basetable-taulukkolaskennan-kaltainen-tietokanta-netissa-ilman-koodausta-154/f/jaa-tietokanta-kenttakohtaisin-oikeuksin
- `zh`: https://aistohire.com/zh/basetable-no-code-spreadsheet-database-154/f/share-database-with-field-permissions
- `pl`: https://aistohire.com/pl/basetable-baza-danych-online-jak-arkusz-bez-programowania-154/f/udostepnianie-bazy-danych-z-uprawnieniami-do-pol
- `he`: https://aistohire.com/he/basetable-msd-ntonim-aonliin-bsgnon-gilion-bli-tknot-154/f/leshatef-masad-netunim-im-harshaot-lechol-sade
- `cs`: https://aistohire.com/cs/basetable-online-databaze-ve-stylu-tabulky-bez-programovani-154/f/sdileni-databaze-s-opravnenimi-na-pole
- `id`: https://aistohire.com/id/basetable-basis-data-online-seperti-lembar-kerja-tanpa-coding-154/f/bagikan-database-dengan-izin-per-bidang
