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 in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances 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 no users are available, you can create one by referring to Creating a Database Account.

7. In the displayed dialog box, click OK.