This topic describes how to modify the permissions of a standard account on an ApsaraDB RDS for MariaDB instance. You can reset the permissions of a privileged account to the default settings.
Reset the permissions of a privileged account
Go to the Accounts page.
Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region in which the RDS instance resides.
Click the ID of the RDS instance. In the left-side navigation pane of the page that appears, click Accounts.
On the page that appears, find the privileged account for which you want to reset permissions and click Reset Permissions in the Actions column.
In the dialog box that appears, enter and confirm the new password, and click OK.
Modify the permissions of a standard account
Go to the Accounts page.
Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region in which the RDS instance resides.
Click the ID of the RDS instance. In the left-side navigation pane of the page that appears, click Accounts.
Find the account for which you want to modify permissions and click Edit Permissions.
In the Modify Account Permissions panel, modify the account permissions.
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. Then, select the Read/Write (DDL + DML), Read-only, DDL Only, or DML Only permissions in the Authorized Databases section.
NoteYou can use SQL statements to modify the permissions of a standard account at higher levels of granularity.
Click OK.