This topic describes how to create a privileged account under an ApsaraDB RDS for PostgreSQL instance.
Background information
An ApsaraDB RDS for PostgreSQL instance supports privileged accounts and common accounts. When you use the data transmission service to migrate or synchronize data from an ApsaraDB RDS for PostgreSQL instance, you must use a privileged account.
You can use the account created in this topic when setting Username during the creation of a PostgreSQL data source.
Create a privileged account under an ApsaraDB RDS for PostgreSQL instance
Go to the Accounts page.
Log on to the ApsaraDB RDS console.
In the upper-left corner of the Instances page, select the region where the target instance is located. Then, click the ID of the instance.
On the instance details page, click Accounts in the left-side navigation pane.
On the Accounts page, click Create Account.
In the Create Account dialog box, set the parameters.
Parameter
Description
Database Account
The account must be no more than 63 characters in length and can contain letters, digits, and underscores (_). It must start and end with a letter or digit and cannot start with pg. Reserved keywords are not allowed in the account.
Account Type
Select Privileged Account.
NoteA privileged account has the following privileges on all databases:
SELECT,INSERT,UPDATE,DELETE,TRUNCATE,REFERENCES, andTRIGGER.New Password
The password must be 8 to 32 characters in length and contain three of the four character types: uppercase letters, lowercase letters, digits, and special characters that are !@#$%^&*()_+-=.
Confirm Password
Enter the password again.
Description
Enter the description of the account. It must be 2 to 256 characters in length.
Click OK.
References
Create a PostgreSQL data source
Migrate data from an ApsaraDB RDS for PostgreSQL instance to an Oracle tenant of OceanBase Database