Creating a Database Account

Only administrators that are created during the cluster installation can access the initial database by default. You can also create other database users.

1

openGauss=# CREATE USER joe WITH PASSWORD "*********";

If the following information is displayed, the creation is successful:

1

CREATE ROLE

In this case, you have created a user account named joe, and the user password is ********. Run the following command to set user joe as the system administrator:

openGauss=# GRANT ALL PRIVILEGES TO joe;

Run the GRANT command to set related permissions. For details, see GRANT.

For more information about database users, see Users and Permissions.