Roles in Team Edition

Overview

Roles in DBeaver Team Edition are designed to manage user access effectively and enhance security. This feature allows administrators to assign specific functionalities and access levels to different users, ensuring each team member has the necessary tools while maintaining tight control over sensitive data.

Roles are structured in a tiered manner, each encompassing the functionalities of more task-specific roles:

Administrator

The Administrator role in DBeaver Team Edition is central to configuring the server and managing settings. This role is essential for ensuring that team members can efficiently access the necessary resources without compromising data security.

Important: At least one of the roles must be an Administrator role. There is no limit on the amount number of Administrators that are allowed.

Capabilities

• Configuring server and settings: Responsible for setting up the server and managing settings for other users.
• Creating and managing shared projects: Administrators can create shared projects containing necessary database connections for team collaboration.
• Monitoring user activity: Using the Query manager in the admin panel, Administrators can view, filter, and analyze users' activities.
• Full application access: Post configuration, Administrators have access to all the functionalities of the desktop and web applications.
• Role assignment: Determines the functionalities available to other team members based on their assigned roles.

Developer

The Developer role is designed for users who need comprehensive access to the features of DBeaver Team Edition, focusing on database administration and project development.

Capabilities

• Full feature access: Complete access to all desktop and web version features of DBeaver Team Edition, including database administration.
• Connection and script management: Ability to configure new and edit existing connections, as well as create SQL scripts and resources.

Note: Unlike Administrators, Developers do not manage the server, users, licenses, or track user activity.

Manager

The Manager role is ideal for specialists like data analysts, who are proficient in writing SQL queries but do not partake in software development or connection setup.

Capabilities

• SQL query execution: Managers can access connections in shared projects for database data retrieval.
• Application access: Can use web and desktop applications to view and create scripts and datasets, with editing capabilities based on permissions.

** Tip**: For detailed information about datasets in DBeaver, please take a look at the article Datasets in Team Edition.

Editor and Viewer

The Editor and Viewer roles in Team Edition are tailored for users who primarily interact with data through the web application. These roles are crucial for tasks like report generation, data processing, and analysis, leveraging datasets for various needs.

Capabilities

• Data interaction: Both roles enable viewing, browsing, filtering, and exporting datasets.
• Data modification: Editors can modify data, and give the correct permissions.

Summary

The following table summarizes the capabilities associated with each role in DBeaver Team Edition:

Capability \ Roles	Administrator	Developer	Manager	Editor	Viewer
Full system administration	+	-	-	-	-
Manage users and licenses	+	-	-	-	-
Create/delete projects	+	-	-	-	-
Edit connections	+	+	-	-	-
Private project	+	+	-	-	-
View connections	+	+	+	-	-
Create/edit/delete resources and scripts	+	+	+	-	-
Create/edit datasets	+	+	+	-	-
Create/edit folders	+	+	+	-	-
Use DBeaver desktop	+	+	+	-	-
In-line data editing	+	+	+	+	-
View, browse, filter, export datasets	+	+	+	+	+

"+" indicates the role has this capability, "-" indicates the role does not.