All Products
Search
Document Center

Create an account

Last Updated: Sep 29, 2021

When you create an account under a MySQL tenant, you can associate the account with multiple databases. When you create an account under an Oracle tenant, the account has only the privileges on the corresponding schema.

Procedure

  1. Log on to the OceanBase management console.

  2. In the left-side navigation pane, click Clusters.

  3. On the Clusters page, click the name of the target cluster to go to the Cluster Workspace page.

  4. On the Cluster Workspace page, click the name of the target tenant.

  5. On the tenant page, click Create Account in the upper-right corner, and configure the following parameters as required.

    Parameter

    Description

    Account Name

    The account name. It cannot be set to a reserved keyword, for example, SYS.

    Account Type

    The account type. Valid values: Common Account and Super Account. A common account has privileges to run DML, DQL, and DDL statements in the database. A super account has all privileges.

    A standard account has the following privileges by default:

    • MySQL mode: SELECT on information_schema.*

    • Oracle mode: The following privileges on user schemas: CREATE TABLE CREATE VIEW CREATE PROCEDURE CREATE SYNONYM CREATE SEQUENCE CREATE TRIGGER CREATE TYPE CREATE SESSION EXECUTE ANY PROCEDURE CREATE ANY OUTLINE ALTER ANY OUTLINE DROP ANY OUTLINE CREATE ANY PROCEDURE ALTER ANY PROCEDURE DROP ANY PROCEDURE CREATE ANY SEQUENCE ALTER ANY SEQUENCE DROP ANY SEQUENCE CREATE ANY TYPE ALTER ANY TYPE DROP ANY TYPE SYSKM CREATE ANY TRIGGER ALTER ANY TRIGGER DROP ANY TRIGGER CREATE PROFILE ALTER PROFILE DROP PROFILE

    Associate Account

    Grant privileges to the account, including read/write, DDL-only, DML-only, and read-only privileges. This parameter is optional.

    In MySQL mode, you can grant the following database privileges to the account: Read/write: ALL PRIVILEGES. Read-only: SELECT. DDL: CREATE, DROP, ALTER, SHOW VIEW, and CREATE VIEW DML: SELECT, INSERT, UPDATE, DELETE, and SHOW VIEW

    Password

    The password of the account. The password must be 10 to 32 characters in length and contain three types of the following characters: uppercase letters, lowercase letters, digits, and special characters, including:

    !@#$%^&* ()_ +-=

    Confirm Password

    Enter the password again to confirm it.

  6. Click OK.