Multiple-Schema Permissions
This page describes the permissions required for each step of the multi-schema source datastore creation flow. For the full reference of user roles and how they compare, see User Roles.
Role Requirements
All steps in the multi-schema workflow require the Manager role (or higher: Admin). This is enforced at the endpoint level - users who hold only the Member user role, or only the Editor team permission, cannot access the multi-schema flow.
| Step | Minimum Role | Description |
|---|---|---|
| Discover Catalogs | Manager | List available databases/projects from a connection. |
| Discover Schemas | Manager | List available schemas within a catalog. |
| Validate Schemas | Manager | Test connectivity for selected schemas before creation. |
| Bulk Create Datastores | Manager | Create multiple datastores from selected schemas. |
| Create Group (inline) | Manager | Create a new datastore group during the bulk creation flow. |
| Link Enrichment (after creation) | Member + Editor team permission | Link a destination to each created datastore individually. |
| Unlink Enrichment | Admin | Remove the link from a datastore. |
Team Permissions
In addition to the role requirement, team-level permissions are enforced when datastores are created. This is the same rule that applies to creating a single datastore:
- The user must have Editor permission in at least one of the teams assigned to the new datastores.
- Having Editor in at least one assigned team is sufficient. Membership in every assigned team is not required. Admins bypass this team-permission check.
- If no teams are specified, the datastore is assigned to the public team, so the user must have Editor permission on the public team for the creation to succeed.
Note
Teams specified in the bulk create request that do not exist yet are automatically created. However, the user must still have Editor permission in at least one of the resulting teams.
Connection Permissions
There are no connection-level permissions for schema discovery. Any user with the Manager role can discover catalogs and schemas from any connection in the workspace - the only gate is the role requirement.
Info
This differs from datastore access, which is gated by team membership. A user can discover schemas from a connection even if they do not have access to existing datastores using that connection.
Permission Flow Summary
graph TD
A[User initiates multi-schema flow] --> B{Has Manager role?}
B -->|No| C[Access denied]
B -->|Yes| D[Discover catalogs & schemas]
D --> E[Validate selected schemas]
E --> F[Bulk create datastores]
F --> G{User has Editor permission<br/>in assigned teams?}
G -->|No| H[Creation fails:<br/>Insufficient permissions]
G -->|Yes| I[Datastores created successfully]
I --> J{Link enrichment?}
J -->|Yes| K{Member role +<br/>Editor team permission?}
K -->|No| M[Link fails:<br/>Insufficient permissions]
K -->|Yes| L[Enrichment linked]
J -->|No| L
L --> N[Done]
UI Behavior Without Permission
| Scenario | What the User Sees |
|---|---|
| User is below Manager role | Datastore creation is unavailable. Both single-datastore and multi-schema creation require Manager or Admin. |
| User has Manager role but no Editor team permission | Creation is refused because the user has no Editor access in an assigned team. |
| User has Manager role but is not in specified teams | Bulk creation fails - the user must be a member of at least one of the teams specified in the request, unless the user is an Admin. |