Docs

RDS for PostgreSQL

Managing accounts

Creating an account

This topic describes how to create and delete accounts for databases run on an RDS for PostgreSQL instance.

Prerequisites

You have Creating an instance, and the instance is in the Running status.

Procedure

In the upper-left corner of the top menu bar, select the project and region for the instance.

tip

If the project of the instance has not been set, the project should be selected as All resources.

Click on Instances in the left navigation bar.

On the Instances page, click on the target instance name to enter the instance details page.

Click the Accounts tab on top of the page.

On the Accounts tab, click Create account, and set the following parameters in the pop-up dialog box.

Parameter	Description
Database account	Enter the account name. Naming rules are as follows: The name is unique within the instance. The account name length is 2 to 63 characters. Must start with a letter and end with a letter or a digit. Can contain letters, digits, underscores (_) and hyphens (-). Some reserved characters or keywords are forbidden in database account names. For more information about a list of forbidden keywords, refer to List of reserved keywords. Do not start the name with pg_.
Account type	Select Super account, Normal account, or Instance read-only account as the account type. Super account: You can create multiple super accounts in an instance to manage all normal accounts and databases. Normal account: Multiple accounts can be created in one instance, and only operations permitted by permissions can be performed in authorized databases. Instance read-only account: Multiple accounts can be created in one instance, only has read-only permissions on all databases under the instance.
Password	Set the account password. Requirements are as follows: The password length is limited to 8~32 characters. The password consists of any three types of characters as follows: uppercase letters, lowercase letters, digits, and special characters. Special characters include !@#$%^*&()_+-=.
Confirm password	Enter the password again.
Account privileges	You can set the following permissions for your account: Login: Login. Inherit: Inheritance. CreateRole: Create a role. CreateDB: Creates the database. tip The super account has all four permissions and does not need to be set separately. Permissions can be set for normal accounts as required. If you are creating an instance read-only account, no account permission settings are required.

Click OK.

Last updated: 2025.11.17 16:15:05