What Are the Roles in the Redgate Data Modeler Team Account? What Can Each Role Do?

Still use individual accounts for your data modeling team members? Try the Redgate Data Modeler team account and see how easy collaboration on database models can be.

Guest post

This is a guest post from Redgate Data Modeler.

Are you working on a team data modeling project? Find out about Redgate Data Modeler’s team account and how it can help you collaborate on a database model.

Collaborating on database models, especially remotely, is challenging enough. Why pay for separate user accounts? In this article, we’ll explain Redgate Data Modeler’s new team account, its user roles, and its benefits. The Redgate Data Modeler team account makes collaboration on database models easier and more efficient. Let’s see why.

Redgate Data Modeler Team Accounts and Roles

Redgate Data Modeler account can be personal (either Basic or Premium) or a team account. If you work on a company’s data modeling with a team, you can create a team account instead of having many individual personal accounts for each member. Plus, team accounts allow you to add members and assign them different roles. Team plans can have from 5 to 50 users and are priced according to the number of users. A team account plan has all features of a Premium personal plan, plus some additional features that are great for data model collaboration.

A team account has the following roles:

  • Redgate Data Modeler User: This is the most used and most important role in a Redgate Data Modeler team account. The main purpose of using Redgate Data Modeler is to model your data; the user account has all the privileges to create logical and physical data models from scratch and use automated features that create DDL files, develop physical data models from logical models, and reverse engineer data models from existing databases. It also allows you to share your models with others. Normally, most technical team members will be assigned this role.
  • Team Administrator: A team administrator manages the list of all users. In this role, they can add members, lock members, reset passwords, and modify roles for others in a Redgate Data Modeler team account. As an example, a project manager would have team administrator privileges in the team account.
  • Payment Administrator: A payment administrator pays for the service and manages other financial details (e.g. they can change billing information, the company name, email address, credit card information, etc.). This is not a role for a technical person; it should go to a responsible finance person within the company.
  • System Administrator: The system administrator can change the account configuration to meet team or company requirements. This role usually goes to a responsible person in the IT team.

User Role Management in Redgate Data Modeler Team Accounts

In a Redgate Data Modeler team account, each member can be associated with one or more roles: Redgate Data Modeler user, team administrator, payment administrator, or system administrator. If you have team administrator privileges, you can see user management options under the Users submenu (under the Team menu in the Redgate Data Modeler main menu).

Collaboration on database model

Effective user management means better collaboration on database models. By adding a new team member, changing user roles, or assigning more roles to a team member, you can make it easier for everyone to work together. And you can control access by locking user accounts or resetting account passwords. All of this can be done in user management.

Changing Roles in a Redgate Data Modeler Team Account

The most important and the most frequent task in user management is adding and changing members’ roles in a Redgate Data Modeler team account. It can be essential to the proper management of a project. Here’s how you do it:

  1. Under the Redgate Data Modeler main menu, select Team and then User. This will open the Users
  2. In the Users panel, there’s a list of all users in your team account. Click on the name of the person whose role you want to change.

Collaboration on database model

  1. The User details panel will be displayed for the selected user. Under Roles, you can see the roles assigned to that user. Click the Change roles button to change this user’s role(s).

Collaboration on database model

  1. You’ll see checkboxes for each available role in the team account. You can check or uncheck each role to grant or remove the associated

Collaboration on database model

And that’s that – you’ve changed user roles in a Redgate Data Modeler team account!

Why Collaborating on Database Modeling Is Easier with Redgate Data Modeler

If you are working with a team on a data modeling project, you can get more benefits by moving to a team account. You get access to different user roles: Redgate Data Modeler user, team administrator, payment administrator, and system administrator. You can assign one or many roles to each team member to best facilitate collaboration on the database model.

Why not experience the difference in using a Redgate Data Modeler team account?

Tools in this post

Redgate Data Modeler

Design, update, and manage database schemas

Find out more