Updated on 2023-07-06 GMT+08:00

Granting Permissions to a User

Scenarios

You can authorize custom database users to specified databases. For authorized users, you can also revoke permissions for them.

Constraints

Permissions cannot be granted to custom database users for DB instances that are 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.