Urgent.News

What's breaking now, across thousands of outlets.

Tech

NocoDB app matches point to API token governance

NocoDB app matches point to API token governance NocoDB turns databases into spreadsheet-like applications. A self-hosted deployment can contain customer records, internal inventories, workflow data, and API tokens. An exposed login or application page is a starting point for inventory, but the more important questions are which workspace it serves and which tokens can reach that workspace. What…

NocoDB, a self-hosted database application, turns database data into spreadsheet-like interfaces. These applications can contain sensitive information such as customer records, internal inventories, and API tokens. When a NocoDB instance is exposed, it can unintentionally grant access to these valuable assets.

In a recent discovery, ZoomEye identified 703 instances of the NocoDB application across the internet. The same scan also found 363 references to the title "NocoDB," suggesting a smaller subset of potential targets. However, these counts alone do not confirm any exposed workspaces or tokens.

NocoDB's documentation outlines the management of API tokens, Single Sign-On (SSO)-enabled workspaces, and token permissions. A deployment can be designed for public use, and the access model varies based on the edition, configuration, and roles assigned to the token owner. Users can log in using email/password, Google, OIDC, SAML, or other providers, and the review process should consider all these authentication methods.

API tokens should have the minimum required permissions and should be rotated or disabled when an integration is retired or a token owner changes roles. NocoDB also supports self-hosting options, allowing organizations to maintain control over their data and deployments.

To mitigate the risk of unauthorized access, organizations should review NocoDB instances for proper access controls, including:

- Identifying every workspace and the users who can administer it

- Ensuring SSO enforcement is properly configured

- Verifying API token creation time, expiry, last use, and purpose

- Rotating or disabling tokens when no longer needed

- Testing the actual lifecycle of tokens in the deployed version

- Reviewing public applications and data exposure

- Restricting database and internal service ports to the application network

- Applying network restrictions to the administrative interface

By carefully managing access controls and monitoring NocoDB instances, organizations can minimize the risk of exposing sensitive data and API tokens.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

Read the original at dev.to →

More in Tech

Build a PWA Icon Pack in the Browser: 8 Sizes, a Manifest and a README

I work on OnePassApps. We build browser studios that do their work in the tab instead of uploading your files, and Icon Studio is the one for icons: eight tools on one tab bar - SVG to PNG, PNG to…

  • Icon Studio creates complete PWA icon sets in browser
  • Generates 8 sizes, manifest, README in single ZIP file
  • Supports SVG/PNG up to 5/24 MiB, outputs up to 512px

Renaming a column in SQL Server, and what it quietly breaks

A column was misspelled when the table was created, and it has been Ammount ever since. The rename itself is one line: EXEC sp_rename 'dbo.Invoice.Ammount' , 'Amount' , 'COLUMN' ; Caution: Changing…

  • Renaming a column can break scripts and stored procedures referencing the old name
  • Issues with invalid column names cause failures in views and procedures
  • Review all referencing objects before renaming to prevent errors

More from Tuesday 3 November →