Create a user and grant permissions for an OBKV instance

Background information

OBKV instances support two types of accounts: standard accounts and super accounts. When you use Data Transmission Service to migrate data to an OBKV instance, you must create a super account. A super account has read and write permissions on all databases by default.

The super account created in this topic is used for the Username parameter when you create a data source for an OceanBase OBKV instance.

Create a super account for an OBKV instance

1. Go to the Tenant Workbench.

   1. Log on to the OceanBase Management Console .

   2. In the upper-left corner of the console, select the region where the target instance is located.

   3. In the navigation pane on the left, click Instance List, and then click the name of the target instance where the Series is Standard Edition (Key-Value).

      

   4. On the Cluster Instance Workbench page, click Tenant Management in the navigation pane on the left.

   5. Click the name of the target tenant to go to the Tenant Workbench.

      Note

      Currently, OBKV instances are supported only by MySQL tenants of OceanBase Database.

      

2. On the Tenant Workbench page, click Account Management in the navigation pane on the left.

3. On the Account Management page, click Create Account in the upper-right corner.

   

4. In the Create Account dialog box, configure the parameters.

   

   Parameter	Description
   User Name	The username must start with a letter and can contain uppercase letters, lowercase letters, digits, and underscores (_). The username must be 2 to 32 characters in length.
   Account Type	Select Super Account. This account type has read and write permission for all databases by default.
   Password	The password must be 10 to 32 characters long and contain characters from at least three of the following categories: uppercase letters, lowercase letters, numbers, and special characters (including !@#$%^&*()_+-=). You can also click Randomly Generate to automatically fill in the password. Note You can click Copy Password to copy the password and save it in a secure location.
   Remarks (Optional)	Enter remarks for the account.

5. Click OK.