TencentDB for SQL Server supports modifying account permissions as needed. However, permissions of the admin account cannot be modified to specified permissions.
Log in to the TencentDB for SQL Server Console. In the instance list, click an instance name or Manage in the "Operation" column to enter the instance management page.
Select the Manage Account tab, select the desired account, and click Modify Permissions in the "Operation" column.
In the pop-up dialog box, select or deselect the authorized databases or permissions and click OK to complete the modification.