Creating a GaussDB Database User

Scenarios

When you create a GaussDB instance, the root user is created at the same time by default. You can add other users as required.

Constraints

Only primary/standby instances of version 8.100.0 or later are supported.

Creating a Database User Through DAS

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, locate the DB instance you want to log in to and click Log In in the Operation column.

   Alternatively, click the DB instance name on the Instances page. On the displayed Basic Information page, click Log In in the upper right corner of the page.

5. On the displayed login page, enter the username and password and click Log In.
6. On the top menu bar, choose SQL Operations > SQL Query.
7. Create a database user.

   create user username;

Creating a Database User Through SQL Statements

You can also use the CREATE USER to create a database user.