Granting Database Permissions

Scenarios

You can grant permissions to database users you have created to use specific databases or revoke permissions from specific database users.

Constraints

Permissions cannot be granted to database users for a DB instance that is 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 Databases. On the displayed page, locate the target database and click Authorize in the Operation column.
6. In the displayed dialog box, select unauthorized users and click to authorize them or select authorized users and click to revoke permissions.

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

7. In the dialog box, click OK.