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
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 and then click the ID of the 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
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 and then click the ID of the instance.
In the left-side navigation pane of the page that appears, click Accounts. On the page that appears, find the account for which you want to modify permissions and then click Change Permissions.
In the Edit Account Permissions panel, select the database and click the
or 
icon.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.