This topic describes how to modify the permissions of a standard account or a system admin account on an ApsaraDB RDS for SQL Server instance. A privileged account has all permissions on all databases. You do not need to modify the permissions of a privileged account.
Procedure
- Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane of the page that appears, click Accounts.
Find the account for which you want to modify permissions and click Change Permissions.
In the Edit Account Permissions panel, modify the permissions of the account.
To add or remove a database, select the database and click the
or 
icon. To modify the read and write permissions, set the permissions to Read/Write (DML), Read-Only, or Owner in the Authorized Databases section.
Click OK.