SCIM

Overview

SCIM (System for Cross-domain Identity Management) is an open standard protocol (v2.0). It sends user and group identity information from your identity provider (IdP) to NocoDB automatically. You do not add and remove users from your organization manually. Your IdP does this for you.

When SCIM provisioning is enabled, your identity provider can do these actions:

ActionWhat it does
Create usersAdds users to your NocoDB organization automatically when you assign them in the IdP.
Update usersSyncs profile changes (display name, email, and others) from the IdP to NocoDB.
Deactivate usersSoft-deletes organization members when you unassign or deactivate them in the IdP.
Manage groupsCreates, updates, and deletes org-level teams in NocoDB that mirror your IdP group structure.
SCIM is a paid add-on. It is not included in any plan, including Enterprise. You can add it to a Scale or Enterprise plan, on self-hosted and on NocoDB Cloud. Refer to Availability.
SCIM provisioning handles identity lifecycle management (who has access). It is complementary to SSO (SAML/OIDC), which handles authentication (how users sign in). For best results, configure both SSO and SCIM with the same identity provider.

Enabling SCIM in NocoDB

Prerequisites

  • The SCIM add-on on a Scale or Enterprise plan (self-hosted or NocoDB Cloud). On self-hosted, the add-on is part of your license key.
  • Org Admin access in NocoDB
  • Admin access to your identity provider (Okta, Azure AD / Entra ID, and others)
  • SSO configured with the same IdP (recommended, not required)

Step 1: Navigate to SCIM settings

  1. In the bottom-left corner of NocoDB, open the user menu. Select Admin Panel.
  2. In the sidebar menu, select SCIM.

Navigate to SCIM settings

Step 2: Enable SCIM provisioning

In the SCIM Provisioning section, click the Configure button. NocoDB generates the SCIM endpoint URL and a provisioning token. NocoDB also enables provisioning automatically.

Step 3: Copy the SCIM endpoint and token

When SCIM is configured, the page shows these details:

DetailWhat it is
SCIM Endpoint URLThe base URL for all SCIM API calls. For example: https://app.nocodb.com/api/v3/meta/orgs/{orgId}/scim/v2
Bearer TokenA bearer token that authenticates SCIM requests.

SCIM configured with token visible

The bearer token is shown only once when first generated. Copy it immediately and store it securely. If you lose it, you can regenerate it, but the previous token will be invalidated.

Step 4: Configure your identity provider

Use the SCIM Endpoint URL and the Provisioning Token to configure SCIM in your IdP. NocoDB supports SCIM provisioning with Okta and Azure AD (Entra ID). For the steps to configure a SCIM application, refer to the documentation of your identity provider.

Microsoft Entra ID

  1. In the Microsoft Entra admin center, go to Enterprise applications. Open the application that you use for NocoDB SSO, or create a non-gallery application.
  2. Select Provisioning, and set Provisioning Mode to Automatic.
  3. In Admin Credentials, enter the SCIM Endpoint URL as the Tenant URL and the Bearer Token as the Secret Token. Click Test Connection, then Save.
  4. In Users and groups, assign the users and groups to provision.
  5. Set Provisioning Status to On.

NocoDB uses the work email that Entra sends as the email of the user. Make sure that it matches the email that users sign in with through SSO.

Step 5: Assign users and groups

In your IdP, assign users, groups, or both to the NocoDB SCIM application. The IdP then sends these assignments to NocoDB through the SCIM API.

How it works

User provisioning

When you assign a user to the NocoDB application in your IdP, the IdP sends a SCIM POST /Users request. NocoDB creates an organization member with the configured default role. The default is Org-Viewer. After provisioning, you can do these actions with an org member:

  • Invite the member into org-level teams
  • Assign roles to the member at the workspace or project level
  • Add the member to workspace teams

Org Admins can change the org role in NocoDB at any time.

If you unassign or deactivate a user in the IdP, NocoDB soft-deletes the organization member. NocoDB keeps the data and contributions of the user. The user loses access to the organization and all its workspaces.

If you re-assign a deactivated user in the IdP, NocoDB reactivates the organization membership. The user keeps the org role they had before deactivation, unless the IdP sends a role with the request. NocoDB also puts the user back into the SCIM teams they were in, so the workspace and project access that those teams give comes back. Refer to Give new users workspace access automatically.

NocoDB does not restore access that was granted by hand: a direct workspace or project role, or membership of a team that is not managed by SCIM. Give that access again yourself. On self-hosted, a reactivation also needs enough seats for the teams it restores. If the license has no seat headroom, the reactivation fails until you free or add seats.

If the IdP deletes the user instead of deactivating them, a later re-assignment starts fresh, with the default role and no teams.

Group provisioning

SCIM groups map to org-level Teams in NocoDB. When the IdP sends a group, NocoDB creates a matching organization team. The team has a SCIM badge and shows "Identity Provider" as the creator. NocoDB adds the members of the IdP group to the NocoDB team automatically.

When you add or remove members of a group in the IdP, NocoDB syncs the change in real time through SCIM PATCH operations.

SCIM-provisioned teams

Give new users workspace access automatically

User provisioning adds a user to the organization only. To give provisioned users a workspace role without inviting each one, use group provisioning:

  1. Assign an IdP group to the NocoDB SCIM application. NocoDB creates an org team for the group.
  2. Assign the org team to the workspace once, with the role that its members must get. You can also give the team project roles.
  3. When you add a user to the group in the IdP, NocoDB provisions the user, adds the user to the team, and the user gets the workspace role of the team. When you remove the user from the group, the user loses that access.

If a user has a direct workspace role, that role applies instead of the team role. Refer to effective role resolution.

SCIM-managed vs. manually-created users

NocoDB marks users from SCIM as SCIM-managed. These users have a blue SCIM badge in the User Management list. The differences are:

  • The IdP controls the lifecycle (activation and deactivation) of SCIM-managed users.
  • The Org Admin can still change their org roles in NocoDB.
  • SCIM operations do not change manually created users.
  • You cannot remove SCIM-managed users directly in NocoDB. Remove them in your identity provider.

SCIM managed users in members list SCIM managed user actions

Managing SCIM

Toggling provisioning

To pause SCIM provisioning and keep the configuration, turn off the SCIM switch in Admin Panel > SCIM settings. While provisioning is paused, NocoDB rejects all incoming SCIM requests. To start provisioning again, turn on the switch.

Default role for new users

The default role is the org-level role that SCIM-provisioned users get. To set it, use the Default Role for New Users dropdown on the SCIM settings page. The options are:

RoleDescription
Org-ViewerCan access workspaces and projects they are invited to; cannot create new workspaces (default)
Org-CreatorSame as Org-Viewer, plus can create new workspaces within the organization

Regenerating the token

If the provisioning token is compromised or lost:

  1. Go to Admin Panel > SCIM.
  2. Next to the provisioning token, click the Regenerate button.
  3. Copy the new token.
  4. Update the token in your IdP configuration.
Regenerating the token immediately invalidates the previous token. Your IdP will fail to sync until you update it with the new token.

Disabling SCIM

To remove SCIM provisioning completely:

  1. Go to Admin Panel > SCIM.
  2. In the danger zone section, click Remove.
  3. Confirm the deletion.
Disabling SCIM stops all provisioning but does not remove SCIM-managed users from the organization. They remain as regular organization members.

Availability

  • SCIM provisioning is a paid add-on, billed per seat. It is not included in any plan, including Enterprise.
  • You can add it to a Scale or Enterprise plan, both self-hosted and on NocoDB Cloud.
  • On self-hosted, the add-on is part of your license key. After NocoDB adds it, activate the updated license. Then SCIM opens in the Admin Panel.
  • For pricing and access, reach out to sales team.

Last updated on

Latest product updates?See Changelog
Stay in the loop? Follow us onLinkedInLinkedInYouTubeYouTubeXX