ApsaraDB RDS:Lock or delete an account from an ApsaraDB RDS for PostgreSQL instance

Lock an account in the ApsaraDB RDS console

1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
2. In the left-side navigation pane, click Accounts.
3. Find the account that you want to lock, and click Lock Instance in the Actions column. In the message that appears, click OK.
   Note Wait a few minutes. When the Status column displays Locking, the account is locked. If you want to use the account again, click Unlock in the Actions column.

Delete an account in the ApsaraDB RDS console

1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
2. In the left-side navigation pane, click Accounts.
3. Find the account that you want to delete, and click Delete in the Actions column.
4. In the message that appears, click OK.

Delete a standard account by using SQL statements

1. Use Alibaba Cloud Data Management (DMS) to log on to the RDS instance. For more information, see Use DMS to log on to an ApsaraDB RDS for PostgreSQL instance.
2. In the top navigation bar, click SQL Console.
3. Execute the following statement to grant the permissions of the account to another account:

   REASSIGN OWNED BY <The username of the account that you want to delete> TO <The username of another account>;

4. Execute the following SQL statement to delete the account:

   DROP USER <The username of the account that you want to delete>;

5. Click execute.
   

Related operations