This topic describes how to manage databases. For example, you can log in to a database, create a database, and manage accounts.
Background information
You can log in to the database to manage database objects, import and export data, edit and execute SQL, compile and debug PL, process data and schemas, perform analysis, and perform database maintenance. For more information, see SQL console overview. By managing accounts in the database, you can configure different access permissions for various accounts based on business requirements.
Procedure
Log in to the OceanBase Cloud console.
On the instance list page, click the name of the target cluster instance to navigate to the instance overview page.
In the left-side navigation pane, click Databases. In n the upper-right corner of the Databases page, you can connect to a database, connect to the SQL console, and create a database. For more information, see Connect to a Database and Create a Database.
You can view information such as the database name, character set, status, bound account, and used disk in the database list.
Click the More icon under the Actions column and select Manage Account to grant database privileges to different accounts as needed.
- DDL: SHOW DATABASES、SHOW VIEW、CREATE、CREATE VIEW、DROP、INDEX、ALTER
- DML: SELECT、DELETE、INSERT、UPDATE
- Read-only: SELECT
- Read/Write: ALL
Note
When an account is granted a specific permission (such as Read/Write), after logging into the corresponding database with that account, if a permission switch is performed on the console (for example, switching to read-only), it is necessary to re-establish the connection for the new permissions to take effect.
- You can delete the database by clicking the More icon under the Actions column and selecting Delete.