Actions on Data sources
Edit external database configuration parameters
- Access
Data Sources
tab in theBase Settings
- Click on
Connection Details
tab - Re-configure database credentials as required
info
Please make sure database configuration parameters are valid. Any incorrect parameters could lead to schema loss!
Remove data source
- Access
Data Sources
tab in theBase Settings
- Click on
Delete
icon listed underActions
column for the data source that you wish to remove
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
- Access
Data Sources
tab in theBase Settings
- Toggle radio button listed under
Visibility
column for the data source that you wish to hide/un-hide
UI Access Control
info
UI Access Control is available only in Open-Source version of NocoDB.
Access Data Sources
tab in the Base Settings
to manage UI access control for the data source.
- Click on
UI ACL
button listed underActions
column for the data source that you wish to manage UI access control for - 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.
- Click on
Save
button to save the changes
Audit logs
Access Data Sources
tab in the Base Settings
to access Audit logs for the data source.
- Click on
Default
datasource & then - Access
Audit
tab to view the audit logs.
info
Audit logs are not available for external data source connections.
Relations
Access Data Sources
tab in the Base Settings
to access Relations view for the data source.
- Select the data source that you wish to access ERD (Relations view) for
- Click on
ERD
tab
Junction table names within Relations
- Enable
Show M2M Tables
withinProject 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.