ApsaraDB RDS for MariaDB supports two types of account permission management through the console: resetting a privileged account to its default permissions, and modifying the database-level permissions of a standard account.
Prerequisites
Before you begin, ensure that you have:
An ApsaraDB RDS for MariaDB instance
A privileged account or standard account created on the instance
Reset the permissions of a privileged account
Resetting a privileged account restores its permissions to the default settings. This operation also requires you to set a new password for the account.
Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the instance resides, and then click the instance ID.
In the left-side navigation pane, click Accounts. Find the privileged account whose permissions you want to reset, and then click Reset Permissions in the Actions column.
In the dialog box, enter and confirm the new password, and then click OK.
Modify the permissions of a standard account
Standard account permissions are granted per database. You can assign one of four permission levels to each database.
Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the instance resides, and then click the instance ID.
In the left-side navigation pane, click Accounts. Find the account whose permissions you want to modify, and then click Change Permissions.
In the Edit Account Permissions panel, select the target database and click the
or
icon to move it into or out of the Authorized Databases section.In the Authorized Databases section, select the Read/Write (DDL + DML), Read-only, DDL Only, or DML Only permission level for the database.
NoteTo assign permissions at a finer granularity than the four preset levels, use SQL statements directly on the database.
Click OK.