All Products
Search
Document Center

ApsaraDB RDS:Modify or reset account permissions

Last Updated:Sep 26, 2023

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

  1. Go to the Accounts page.

    1. 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.

    2. Click the ID of the RDS instance. In the left-side navigation pane of the page that appears, click Accounts.

  2. On the page that appears, find the privileged account for which you want to reset permissions and click Reset Permissions in the Actions column.

  3. In the dialog box that appears, enter and confirm the new password, and click OK.

Modify the permissions of a standard account

  1. Go to the Accounts page.

    1. 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.

    2. Click the ID of the RDS instance. In the left-side navigation pane of the page that appears, click Accounts.

  2. Find the account for which you want to modify permissions and click Edit Permissions.

  3. 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.

      Note

      You can use SQL statements to modify the permissions of a standard account at higher levels of granularity.

  4. Click OK.