Modify or reset account permissions
You can modify the permissions of a standard account or reset the permissions of a high-privilege account to their initial state.
Reset high-privilege account permissions
-
Log on to the RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select a region and click the target instance ID.
-
In the left-side navigation pane, click Accounts. Find the target high-privilege account, and in the Actions column, click Reset Account Permissions.
-
In the dialog box that appears, enter and confirm a new password, and click OK.
Modify standard account permissions
-
Log on to the RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select a region and click the target instance ID.
-
In the left-side navigation pane, click Accounts. Find the account whose permissions you want to modify, and in the Actions column, click Change Permissions.
-
On the Edit Account Permissions page, select one or more databases and click
or 
. -
In the Authorized Databases section, set the permissions to Read/Write (DDL + DML), Read-only, DDL Only, or DML Only.
NoteFor more fine-grained permissions, use SQL commands.
-
Click OK.