Help Center > > User Guide> Working with RDS for MySQL> Account Management (Non-Administrator)> Changing Permissions

Changing Permissions

Updated at: May 26, 2020 GMT+08:00

Scenarios

You can authorize custom database users to specified databases and revoke permissions for authorized databases.

Constraints

Permissions cannot be changed 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 RDS. 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 Accounts. On the Accounts page, locate the target username and choose More > 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.

    Figure 1 Changing permissions
    • If there are no unauthorized databases, you can create one by referring to Creating a Database.
    • If you require fined-grained authorization, log in to the database through the DAS console.

  7. Click OK.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel