All videos

Databases · 1:31

Who can see and change the data

Share a database, see the job accounts that use it, and check its row access.

Transcript

0:00Who can see and change the data

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.