Manage databases

This topic describes how to manage databases in the OceanBase Cloud console.

Procedure

1. Log in to the OceanBase Cloud console. In the left-side navigation pane, click Instances.

2. On the instance list page, click the name of the target cluster instance to navigate to the Overview page of the instance.

3. In the left-side navigation pane, click Tenants.

4. On the Tenants page, click the name of the target tenant in the Tenants list to go to the Overview page of the tenant.

5. In the left-side navigation pane, click Databases.

6. Click Create Database to create a database.

7. In the databases list, check the following parameters to obtain information about each database: Database Name, Character Set, Status, and Account.

8. Click Manage Account for a database in the Actions column to grant database privileges to different accounts as needed.

   • If you select Only DDL, the following privileges are granted: SHOW DATABASES, SHOW VIEW, CREATE, CREATE VIEW, DROP, INDEX, and ALTER.

   • If you select Only DML, the following privileges are granted: SELECT, DELETE, INSERT, and UPDATE.

   • If you select Read-only, the SELECT privilege is granted.

   • If you select Read/Write, all preceding privileges are granted.