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

• Take care when changing account permissions. Inappropriately configured account permissions can impact the DB instance or workloads.
• 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 instance name to go to the Overview page.
4. In the navigation pane on the left, choose Databases and Accounts and then click the Accounts tab.
5. Locate the target account and click 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.