Skip to main content
Version: Latest

Actions on Data sources

Edit external database configuration parameters​

  1. Access Base context menu by clicking on the Base name in the left sidebar
  2. Click on Data Sources tab
  3. Click on Edit icon listed under Actions column for the data source that you wish to access ERD (Relations view) for Go to Data Sources, click Edit icon, you can re-configure database credentials.
    Please make sure database configuration parameters are valid. Any incorrect parameters could lead to schema loss!

relations

edit db config

Remove data source​

  1. Access Base context menu by clicking on the Base name in the left sidebar
  2. Click on Data Sources tab
  3. Click on Delete icon listed under Actions column for the data source that you wish to Unlink

datasource unlink

note

Unlinking a data source will not delete the external data source. It will only remove the data source from the current project.

Data source visibility​

  1. Access Base context menu by clicking on the Base name in the left sidebar
  2. Click on Data Sources tab
  3. Toggle radio button listed under Visibility column for the data source that you wish to hide/un-hide

datasource visibility

UI Access Control​

info

UI Access Control is available only in Open Source version of NocoDB.

  1. Access Base context menu by clicking on the Base name in the left sidebar
  2. Click on Data Sources tab
  3. Click on UI ACL button listed under Actions column for the data source that you wish to manage UI access control for
  4. On the UI ACL modal, you can see the list of tables available in the data source as rows & roles available as columns. Toggle checkboxes to enable/disable access to tables for specific roles.
  5. Click on Save button to save the changes

ui acl

ui acl

Audit logs​

  1. Access Base context menu by clicking on the Base name in the left sidebar
  2. Click on Data Sources tab
  3. Click on Audit button listed under Actions column for the data source that you wish to access Audit logs for

audit

audit logs

Relations​

  1. Access Base context menu by clicking on the Base name in the left sidebar
  2. Click on Data Sources tab
  3. Click on Relations button listed under Actions column for the data source that you wish to access ERD (Relations view) for

relations

relations

Junction table names within Relations​

  • Enable Show M2M Tables within Project Settings menu
  • Double-click on Show Fields to see additional checkboxes get enabled.
    • Enabling which you should be able to see junction tables and their table names.

image