You can modify the permissions of a standard account created on an ApsaraDB RDS for MySQL instance. The permissions of a privileged account can only be reset to the default settings.
Modify the permissions of a standard account
- Log on to the ApsaraDB for RDS console.
- In the top navigation bar, select the region where the target RDS instance resides.
- Find the target RDS instance and click its ID.
- In the left-side navigation pane, click Accounts.
- Find the account for which you want to modify the permissions and click Edit Permissions in the Actions column.
- On the Accounts page, modify the permissions of the standard account.
- Modify the authorization on databases: Select one or more databases and click Add or Remove.
- Specify the permissions on authorized databases: In the Authorized Databases section, specify the Read/Write, Read-only, or Owner permissions on a single authorized database. Alternatively, specify permissions on all of the authorized databases simultaneously by clicking the button in the upper-right corner. The button shows Set All to Read/Write, Set All to Read-only, and Set All to Owner as you click it.