Updated on 2024-05-07 GMT+08:00

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
gaussdb=# 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 ********. Set user joe as a system administrator.

gaussdb=# 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.