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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot