nav-img
Advanced

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