Updated on 2024-07-18 GMT+08:00

Changing Permissions for a Database Account

Scenarios

You can authorize database users you have created to specific databases or revoke permissions from authorized database users.

Constraints

  • Permissions cannot be changed for DB instances that are in the process of being restored.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  3. On the Instances page, click the target DB instance.
  4. In the navigation pane on the left, choose Accounts. On the Accounts page, locate the target username and click Change Permission in the Operation column.
  5. 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.

  6. Click OK.