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