You can modify the permissions of a standard account that is created on an ApsaraDB RDS for SQL Server instance. The permissions of a privileged account can only be reset to the default settings.

Procedure

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target instance and click the instance ID.
  4. Find the target standard account and in the Actions column click Edit Permissions.
  5. In the Modify Account Permissions pane, modify the permissions of the standard account.
    • If you want to add or remove an authorized database, select the database and click the > or < icon.
    • If you want to modify the permissions on an authorized database, select the database and then select the Read/Write (DDL), Read-only, or Owner permissions in the Authorized Databases section.
  6. Click OK.