- Sam’s Refund review app should list open refund requests from the Refund cases database.
- Sam owns that database, yet the app says it cannot read it.
- An app works with its own access, not the access of the person using it.
- Settings lists the databases the app can use. This app has none yet.
- Add database offers the databases you own. Sam picks Refund cases.
- Read only lets the app read the schema and select rows.
- Read and change also lets it insert, update and delete. Row rules still apply.
- The page only lists requests, so Sam keeps Read only and adds the database.
- The database also shows as a tab on the app’s page.
- Reload the preview. The app now reads the rows with its own grant.
- Only the database’s Owner can add or change this access.
- Saving the app’s code gives it no access. Sharing the database does.