Updated on 2023-07-06 GMT+08:00

Changing Permissions

Scenarios

You can authorize custom database users to specified databases and revoke permissions for authorized databases.

Constraints

Permissions cannot be changed for DB instances that are being restored.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. In the navigation pane on the left, choose Accounts. On the Accounts page, locate the target username and choose More > Change Permission in the Operation column.
  6. In the displayed dialog box, select unauthorized databases and click to authorize them. You can also select authorized databases and click to revoke permissions.

    • If there are no unauthorized databases, you can create one by referring to Creating a Database.

  7. Click OK.