Skip to content

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.