Creating a Database Account

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

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.