ApsaraDB for OceanBase:Create a database account for an OBKV instance and grant privileges to the account

Background information

An OBKV instance supports two types of database accounts: normal account and super account. When you use the data transmission service to migrate data to an OBKV instance, create a super account, which has read/write privileges on all databases by default.

The name of the super account created for your OBKV instance can be used as the value of the Username parameter when you create an OBKV data source.

Create a super account for an OBKV instance

1. Go to Tenant Workspace.

   1. Log on to the ApsaraDB for OceanBase console.

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

   3. In the left-side navigation pane, click Instances. Then, click the name of the target instance with Series set to Standard Edition (Key-Value).

      

   4. On the Cluster Instance Workspace page, click Tenant Management in the left-side navigation pane.

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

      Note

      Only MySQL tenants of OceanBase Database support OBKV instances.

      

2. On the Tenant Workspace page, click Account Management in the left-side navigation pane.

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
   Username	It must start with a letter and contain 2 to 32 characters in length, including uppercase and lowercase letters, underscores (_), and digits.
   Account Type	Select Super Account. An account of this type has read/write privileges on all databases by default.
   Password	The password must be 10 to 32 characters in length and contain any three of the following character types: uppercase letters, lowercase letters, digits, and special characters. Supported special characters are the following ones: ! @ # $ % ^ & * ( ) _ + - =. You can click Randomly generated to automatically fill in a random password. Note You can also click Copy Password to copy the password and keep it confidential.
   Remarks (Optional)	Enter the description of the account.

5. Click OK.