Manage users

Users are part of an organization. If you are a system administrator, you can manage users in the organization, including inviting users, removing users, and editing user permissions. This article describes the feature.

Introduction to Account Types

NineData provides two types of user accounts: and .

• : Users who register through regular channels (phone number or email) can log in to NineData through both regular and SSO methods. This account type supports all modes (Personal ModeAfter registering for a NineData account, you are usually in Personal Mode by default. In this mode, you can use all four modules provided by NineData without any obstacles. Personal Mode is suitable for individual developers, such as backing up, restoring, synchronizing, and comparing their own databases, as well as daily development work with SQL windows., Organization ModeOrganization Mode supports assigning different roles and resource management permissions to each user under an organization. It is suitable for multi-user collaborative development within the same organization, while ensuring data security and improving overall productivity.,SSO Organization ModeIn addition to the login method, it is consistent with Organization Mode.), and users are responsible for managing and maintaining their account security.
• : Users created by SSO organization can only log in to NineData through the SSO method. After logging in, they directly enter the corresponding SSO organization and cannot enter Personal Mode or non-SSO Organization Mode. Because the account information of SSO users is managed by the Identity Provider (IdP), SSO users have higher security.

Comparison of Account Types

Operation
Regular login method	✔️	❌
SSO login method	❌	✔️
Personal Mode	✔️	❌
Organization Mode (non-SSO)	✔️	❌
SSO Organization Mode	❌	✔️
Switch organization	✔️	❌
Modify username and password	✔️	❌
One-click login	❌	✔️

Invite users

Prerequisites

• Created or joined an organization. For more information, see Managing Organizations.
• The NineData console is in regular organization (non-SSO) mode. To switch from personal mode to organization mode, see Switching to Organization.
• Your role is . For more information, see Roles.

Steps

1. Log in to NineData console.

2. In the left navigation bar, click Account > Users.

   tip

   If Account is not found , verify that your console is in organization mode. About how to switch from personal mode to organization mode, see Switch to Organization.

3. On the Users page, click Invite in the upper right corner.

4. In the Invite dialog box, enter the email address of the member to be invited to the organization, select the role of the member after joining the organization, and click OK. One can also click Add to invite users in bulk.

   tip

   One can create a custom role. For more information, see Manage Roles.

5. Click OK to complete the user invitation. At this point, NineData will send an invitation email to the user's email address, and the user can join the organization after accepting the invitation and completing the registration or login.

Add SSO Users

Prerequisites

• SSO login is enabled for the current organization. For more information, see Enabling SSO login.
• Your role is . For more information, see Roles.
• The user's account must already be added in the identity provider (IdP) application, otherwise the user won't be able to log in. The account in the IdP application and the SSO username to be created are usually corresponding.

Procedure

See Creating an SSO User.

View User List

You can view all users within the current organization and disable/enable or remove users within the organization according to actual business needs, such as when members leave or resign.

Prerequisites

• The NineData console is in organization mode. To switch from personal mode to organization mode, see Switch to Organization.
• Your role is . For more information, see Roles.

Procedure

1. Log in to NineData console.

2. In the left navigation bar, click > to view all users in the current organization.

   tip

   If is not found , verify that your console is in organization mode. About how to switch from personal mode to organization mode, see Switch to Organization.

3. On the page, you can disable/enable or remove users as needed.

   Disable/Enable

   Find the target user and turn on or off the switch in the column on the right side of the user. After disabling a user (turning off the switch), the user will not be able to enter the organization. The user will be restored after being re-enabled.

   Remove User

   Find the user you want to remove and click in the column on the right side of the user. In the pop-up confirmation window, click .

   tip

   You can filter by role category by selecting it in the upper right corner of the page, or you can directly enter a username to search and quickly locate the target user.

Configuring User Access Limits

You can configure and for all users within the organization. The configured query limits will apply to each individual user.

1. Log in to the NineData Console.

2. In the left navigation pane, click on and then to view all users in the current organization.

   tip

   If you don't see , please ensure that your console is in organization mode. For information on how to switch from personal mode to organization mode, refer to Switching to Organization.

3. On the page, click on the icon to the right of .

4. In the popped-up dialog , configure and respectively. The configured counts and row numbers will apply to each user within the organization.

   tip

   The configured counts and row numbers are limits for a single day. If not fully utilized on that day, they will reset to zero and will not accumulate to the next day.

Edit User

For users within the organization, you can individually edit specific users. Editable fields include , , , and .

Among these, and have different functions based on .

• : Modifying and will only change the displayed name in the NineData organization, with no other effects.
• :
  • : Allows changing the login name of SSO users. The new login name must match the complete username of the target user on the IdP provider side. After modification, users must first log in to the IdP provider with the new IdP login information and then smoothly log in to the NineData Console.
  • : Allows changing the displayed name of the target user within the NineData organization.

You can also configure and individually for users:

• : Configures the number of queries the current user can execute per day, defaulting to 2000 queries. The date on the right is the expiration date, meaning the user can execute 2000 queries daily until midnight on that date. Leave it blank for unlimited effectiveness.
• : Configures the total number of rows the current user can query per day, defaulting to 20000 rows. The date on the right is the expiration date, meaning the user can query 20000 rows daily until midnight on that date. Leave it blank for unlimited effectiveness.

tip

• The configured and for specific users take precedence over the global user access limits configuration.
• After the configured and expire for a specific user, the user needs to perform any SQL operation to refresh the quota data (switching to the global user access limits configuration).
• The configured counts and row numbers are limits for a single day. If not fully utilized on that day, they will reset to zero and will not accumulate to the next day.

Prerequisites

• NineData console is in organization mode. To switch from personal mode to organization mode, see Switch to Organization Mode.
• Your role is . For more information, see Roles.

Procedure

1. Log in to the NineData console.

2. In the left navigation pane, click and then to view all users in the current organization.

   tip

   If is not found, confirm that your console is in organization mode. To switch from personal mode to organization mode, see Switch to Organization Mode.

3. In the user list on the page, find the user you want to edit, and click in the column on the right side of the user.

   tip

   You can filter by role classification in the upper-right corner of the page, or directly search for the username to quickly locate the target user.

4. Configure the user settings in the pop-up window, then click on .

Configuring User Permissions

Prerequisites

• NineData console is in organization mode. For instructions on switching from personal mode to organization mode, see Switching to an Organization.
• Your role is . For more information, see Roles.

Procedure

1. Log in to the NineData console.

2. In the left navigation pane, click > to view all users in the current organization.

   tip

   If is not found, confirm that your console is in organization mode. For instructions on switching from personal mode to organization mode, see Switching to an Organization.

3. In the user list on the page, click in the column on the right side of the target user to configure user permissions in the pop-up window of .

   has three sections: , , and .
   • : Shows all permissions that the user has applied for by submitting permission application tickets, which are divided into three sections: , , and . You can click the button on the right side of the target permission to revoke the user's applied permission according to business needs.
   • : Shows the roles that the user has been bound to, and the corresponding permissions for each role. You can click to bind a new role for the user or unbind an existing role.
   • : Shows the individual permissions that have been granted to the user. Individual permissions and other permissions that the user has (, ) are complementary and have no priority. You can grant or revoke individual permissions for the user by turning the slider on the right side of the target permission.
   tip

   For more information on permissions, see Permissions.

4. Click Save Changes.