Share a database with individual users or the owner's team to allow them to edit or use the databases in an app.
- Understand the database permissions
- Share a database with individual users
- Share a database with the database owner's team
- Manage permissions for individual users
- Send users a link to the database
- Restrict external database sharing
Understand the database permissions
The following permissions are supported for AppSheet databases.
Permission
Description
Viewer
- View the database only; can't edit content
- Can temporarily adjust grouping, filtering, and sorting (doesn’t impact other users)
Writer
- View database
- Edit rowdata
- Connect an app to a database
- Can't change table structure (columns, views, etc.)
Editor
- View and edit database
- Share databases with others
- Connect an app to a database
- Can't delete database or tables
Owner
- View and edit database
- Share databases with others
- Connect an app to a database
- Delete a database or table
- Change the owner of a database
Share a database with individual users
To share a database with individual users:
- Open the database in the database editor .
- Click Share.
- Enter the email address of the individual user with whom you want to share your database, such as ahamilton@example.com.
- Repeat to share with additional users.
- Select one of the database permissions .
- Optionally, click Copy link to databaseto share with users.
- Click Save.
Share a database with the database owner's team
Team members are not notified when a database is shared with a team. You can view the databases that are shared with your team, even if you haven't accessed them, by clicking the Shared with mefilter on the My Apps page
.
To share a database with the database owner's team:
- Open the database in the database editor .
- Click Share.
- Select one of the database permissions for Everyone in the owner's team.
- Click Save.
Manage permissions for individual users
To manage permissions for individual users:
- Open the database in the database editor .
- Click Share.
- Change the database permissions for an individual user.
- Click Save.
Send users a link to a database
To send users a link to your database:
- Open the database in the database editor .
- Click Share.
- Click Copy link to database.
- Click Done.
- Send the link to users using your preferred method.
Restrict external database sharing
Restrict the sharing of AppSheet databases to only emails or domains internal to the domain belonging to the app owner's organization. For an AppSheet organization , this includes all secondary domains managed by the parent Google Workspace account, if applicable.
Restrict external database sharing:
- Access the Policies page by selecting one of the following:
- Admin > Policiesin the top navigation
- Policies from the account profile drop-down
- Select the scope, Teamor Account.
- Click + Account Policyor + Team Policyto add an account or team policy, respectively.
- Select Restrict external database sharing from the Policy Templatedrop-down.
- Click Next.
- The policy is preconfigured for you. You can modify any of the field values. See Add a predefined policy
for a description of each field. Important: If you modify the Conditionfield, ensure that you retain the functionality defined below:
NOT([IsSharedExternally])
- Click Save.