Projects in Team Edition

In DBeaver Team Edition, projects serve as organizational units that administrators use to manage and share database resources. These resources include database connections, tasks, SQL scripts, ER diagrams, datasets and bookmarks.

Administrators maintain full visibility over all projects, except for those marked as private. They can view all connections, datasets, and scripts. Administrators are the only role controlling access to each project, allowing specific users and roles to interact with the resources.

The visibility, editing permissions, and other interactions with the project's resources can vary depending on the user's permissions.

The user interface (UI) for managing projects in DBeaver Team Edition may differ slightly between the web and desktop versions. However, the functionality remains consistent across both platforms, ensuring a uniform user experience, except for the Multiple projects feature.

Note: Viewer and Editor roles are not supported in the desktop version of Team Edition. For more information on user roles, refer to role management article.

Web version:

1. As administrator, go to Settings -> Administration.
2. Click on the Projects tab.

3. Click the + Add button and enter the project name.

   

4. For access permissions, go to Access, click Edit, and select users or teams.

5. To add users or teams, check the box next to their names and click the Add button.

   

Desktop version:

1. As administrator, navigate to the Projects view.

Tip: If the Projects view is not open, access it by going to Window -> Projects.

2. Click on the Create Project button .

3. Enter the project name and provide a description (optional).

   

4. For access permissions, go to Window -> Show View -> Administration, and select the newly created project.

5. To add users or teams, press the + Add button, choose one or more users/teams, and click OK.

   

Editing access is quite similar to the steps during the creation of a project:

Web version:

1. As administrator, go to Settings -> Administration -> Projects and select the project.
2. Select the Access tab.
3. To modify access permissions:
   • To add new users or teams, click Edit, check the box next to their names in the right window and click the Add button.
   • To remove existing users or teams, select them in the left window and click the Delete button.

Desktop version:

1. As administrator, navigate to Window -> Show View -> Administration.
2. Select the Projects tab.
3. To modify access permissions:
   • To add new users or teams, press the + Add button, choose one or more users/teams, and click OK.
   • To remove existing users or teams, select them in the Access window and click the Remove button.

Tip: You can also manage project access directly through the Users and Teams configuration interfaces.

To delete a project:

Web version:

1. As administrator, go to the Settings -> Administration -> Projects.
2. Select the checkbox next to the project you wish to remove.
3. Click on Delete button.
4. Confirm the deletion to permanently remove the project.

Desktop version:

1. As administrator, navigate to the Projects view.
2. Select the project you wish to remove, right-click on it, and click Delete button.
3. Confirm the deletion to permanently remove the project.

Web version:

• To switch between different projects you have access to, click the Project Selector button, located in the Toolbar.

  

Desktop version:

• In the desktop version, access the Project view to see all the projects available to you. To open a project and make it active in the Database Navigator, right-click on the desired project and select Set project as active.

  

Note: Depending on the selected project, a different set of database connections, tasks, SQL scripts, ER diagrams, datasets and bookmarks will be displayed.

You can display multiple projects simultaneously in the Database Navigator.

To enable this feature:

1. Use the checkbox Multiple projects in Settings to allow multiple projects in the Database Navigator.

   

2. Choose the projects you want to see in your Database Navigator. Click the Project Selector button, located in the Toolbar.

   

Note: This feature is only available in the web interface of the Team Edition.

You have a default project named Private where you can create connections, scripts, tasks, diagrams, bookmarks and datasets that are not visible to the Administrator. This project operates as a personal space, safeguarding sensitive information and providing a workspace free from disturbances.

To enable or disable the creation of private projects, an administrator needs to go to Settings -> Administration -> Server Configuration and toggle Enable private connections.

Web Version:

• To access your private project, select the Private project using the Project Selector button. If you have enabled the Multiple projects feature, you can open several projects simultaneously, including your private one.

Desktop Version:

• To access your private project in the desktop interface, navigate to the Private project in the Project view, right-click on it and select Set project as active.