- Sam’s Refund intake jobs read and write the Refund requests database. Each job runs as its own account.
- In a job, Access opens Manage access. The Databases tab shows what that job account still needs.
- Saving the job already gave it access to the database it uses, so nothing is left to give.
- The workflow’s tab bar links to that database. Its Share button lists every grant.
- Sam created the database, so Sam is an Owner. Each job account has a grant of its own.
- The query job got View. The write job got Edit, the most a write job is given.
- Sam can also share with a person, a team, or everyone in the organisation. Here, Sam picks Support.
- View reads rows. Edit also adds, changes and deletes them. Owner also changes tables and access.
- Grant access, and the Support team can now add and change rows.
- Row access works inside each table. It decides which rows an account can see and change.
- With the default rules, everyone with access sees every row. Change with chat asks for narrower rules.
- Preview as shows the table the way one person or job account sees it, read-only.
- Previewing as Check earlier refunds shows all five requests, because no rule limits it.